Debian Codegraph @

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

raw
1 call mtr.add_suppression("192.0.2.4");
2 flush global status;
3 flush hosts;
4 flush user_resources;
5 flush privileges;
6 select `User`, `Host` from mysql.`user` where `host` like '%\\%%';
7 User Host
8 select `User`, `Host` from mysql.`user` where `user` like '192.%';
9 User Host
10 select `User`, `Host` from mysql.`user` where `user` like '2001:%';
11 User Host
12 select `User`, `Host` from mysql.`user` where `user` like 'santa.claus.%';
13 User Host
14 create user 'root'@'santa.claus.ipv4.example.com';
15 grant select on test.* to 'root'@'santa.claus.ipv4.example.com';
16 connect con1,"127.0.0.1",root,,test,$MASTER_MYPORT,;
17 select "Con1 is alive";
18 Con1 is alive
19 Con1 is alive
20 select current_user();
21 current_user()
22 root@localhost
23 disconnect con1;
24 connection default;
25 SET @saved_dbug = @@GLOBAL.debug_dbug;
26 set global debug_dbug= "+d,vio_peer_addr_fake_ipv4,getnameinfo_fake_ipv4,getaddrinfo_fake_good_ipv4";
27 connect con2,"127.0.0.1",root,,test,$MASTER_MYPORT,;
28 select "Con2 is alive";
29 Con2 is alive
30 Con2 is alive
31 select current_user();
32 current_user()
33 [email protected]
34 disconnect con2;
35 connection default;
36 # Dumping performance_schema.host_cache
37 IP 192.0.2.4
38 HOST santa.claus.ipv4.example.com
39 HOST_VALIDATED YES
40 SUM_CONNECT_ERRORS 0
41 COUNT_HOST_BLOCKED_ERRORS 0
42 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
43 COUNT_NAMEINFO_PERMANENT_ERRORS 0
44 COUNT_FORMAT_ERRORS 0
45 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
46 COUNT_ADDRINFO_PERMANENT_ERRORS 0
47 COUNT_FCRDNS_ERRORS 0
48 COUNT_HOST_ACL_ERRORS 0
49 COUNT_NO_AUTH_PLUGIN_ERRORS 0
50 COUNT_AUTH_PLUGIN_ERRORS 0
51 COUNT_HANDSHAKE_ERRORS 0
52 COUNT_PROXY_USER_ERRORS 0
53 COUNT_PROXY_USER_ACL_ERRORS 0
54 COUNT_AUTHENTICATION_ERRORS 0
55 COUNT_SSL_ERRORS 0
56 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
57 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
58 COUNT_DEFAULT_DATABASE_ERRORS 0
59 COUNT_INIT_CONNECT_ERRORS 0
60 COUNT_LOCAL_ERRORS 0
61 COUNT_UNKNOWN_ERRORS 0
62 FIRST_ERROR_SEEN null
63 LAST_ERROR_SEEN null
64 connect con3,"127.0.0.1",root,,test,$MASTER_MYPORT,;
65 select "Con3 is alive";
66 Con3 is alive
67 Con3 is alive
68 select current_user();
69 current_user()
70 [email protected]
71 disconnect con3;
72 connection default;
73 # Dumping performance_schema.host_cache
74 IP 192.0.2.4
75 HOST santa.claus.ipv4.example.com
76 HOST_VALIDATED YES
77 SUM_CONNECT_ERRORS 0
78 COUNT_HOST_BLOCKED_ERRORS 0
79 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
80 COUNT_NAMEINFO_PERMANENT_ERRORS 0
81 COUNT_FORMAT_ERRORS 0
82 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
83 COUNT_ADDRINFO_PERMANENT_ERRORS 0
84 COUNT_FCRDNS_ERRORS 0
85 COUNT_HOST_ACL_ERRORS 0
86 COUNT_NO_AUTH_PLUGIN_ERRORS 0
87 COUNT_AUTH_PLUGIN_ERRORS 0
88 COUNT_HANDSHAKE_ERRORS 0
89 COUNT_PROXY_USER_ERRORS 0
90 COUNT_PROXY_USER_ACL_ERRORS 0
91 COUNT_AUTHENTICATION_ERRORS 0
92 COUNT_SSL_ERRORS 0
93 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
94 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
95 COUNT_DEFAULT_DATABASE_ERRORS 0
96 COUNT_INIT_CONNECT_ERRORS 0
97 COUNT_LOCAL_ERRORS 0
98 COUNT_UNKNOWN_ERRORS 0
99 FIRST_ERROR_SEEN null
100 LAST_ERROR_SEEN null
101 revoke select on test.* from 'root'@'santa.claus.ipv4.example.com';
102 drop user 'root'@'santa.claus.ipv4.example.com';
103 SET @@GLOBAL.debug_dbug = @saved_dbug;