Debian Codegraph @

mysql-test/suite/perfschema/r/hostcache_peer_addr.result

raw
1 flush global status;
2 flush hosts;
3 flush user_resources;
4 flush privileges;
5 select `User`, `Host` from mysql.`user` where `host` like '%\\%%';
6 User Host
7 select `User`, `Host` from mysql.`user` where `user` like '192.%';
8 User Host
9 select `User`, `Host` from mysql.`user` where `user` like '2001:%';
10 User Host
11 select `User`, `Host` from mysql.`user` where `user` like 'santa.claus.%';
12 User Host
13 show global status like "connection_errors_%";
14 Variable_name Value
15 Connection_errors_accept 0
16 Connection_errors_internal 0
17 Connection_errors_max_connections 0
18 Connection_errors_peer_address 0
19 Connection_errors_select 0
20 Connection_errors_tcpwrap 0
21 connect con1,"127.0.0.1",root,,test,$MASTER_MYPORT,;
22 select "Con1 is alive";
23 Con1 is alive
24 Con1 is alive
25 select current_user();
26 current_user()
27 root@localhost
28 disconnect con1;
29 connection default;
30 SET @saved_dbug = @@GLOBAL.debug_dbug;
31 set global debug_dbug= "+d,vio_peer_addr_error";
32 ERROR HY000: Can't get hostname for your address
33 connection default;
34 show global status like "connection_errors_%";
35 Variable_name Value
36 Connection_errors_accept 0
37 Connection_errors_internal 0
38 Connection_errors_max_connections 0
39 Connection_errors_peer_address 1
40 Connection_errors_select 0
41 Connection_errors_tcpwrap 0
42 # Dumping performance_schema.host_cache
43 ERROR HY000: Can't get hostname for your address
44 connection default;
45 show global status like "connection_errors_%";
46 Variable_name Value
47 Connection_errors_accept 0
48 Connection_errors_internal 0
49 Connection_errors_max_connections 0
50 Connection_errors_peer_address 2
51 Connection_errors_select 0
52 Connection_errors_tcpwrap 0
53 # Dumping performance_schema.host_cache
54 SET @@GLOBAL.debug_dbug = @saved_dbug;
55 flush global status;
56 show global status like "connection_errors_%";
57 Variable_name Value
58 Connection_errors_accept 0
59 Connection_errors_internal 0
60 Connection_errors_max_connections 0
61 Connection_errors_peer_address 0
62 Connection_errors_select 0
63 Connection_errors_tcpwrap 0