Debian Codegraph @

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

raw
1 flush status;
2 TRUNCATE TABLE performance_schema.host_cache;
3 flush user_resources;
4 flush privileges;
5 select @@global.debug;
6 @@global.debug
7
8 select @@global.max_connect_errors;
9 @@global.max_connect_errors
10 100
11 select @@global.max_user_connections;
12 @@global.max_user_connections
13 0
14 select @@global.max_connections;
15 @@global.max_connections
16 151
17 select `User`, `Host` from mysql.`user` where `host` like '%\\%%';
18 User Host
19 select `User`, `Host` from mysql.`user` where `user` like '192.%';
20 User Host
21 select `User`, `Host` from mysql.`user` where `user` like '2001:%';
22 User Host
23 select `User`, `Host` from mysql.`user` where `user` like 'santa.claus.%';
24 User Host
25 select "Con1 is alive";
26 Con1 is alive
27 Con1 is alive
28 select current_user();
29 current_user()
30 root@localhost
31 set global debug= "+d,vio_peer_addr_fake_ipv6,getnameinfo_fake_ipv6,getaddrinfo_fake_good_ipv6";
32 ERROR HY000: Host 'santa.claus.ipv6.example.com' is not allowed to connect to this MySQL server
33 "Dumping performance_schema.host_cache"
34 IP 2001:db8::6:6
35 HOST santa.claus.ipv6.example.com
36 HOST_VALIDATED YES
37 SUM_CONNECT_ERRORS 0
38 COUNT_HOST_BLOCKED_ERRORS 0
39 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
40 COUNT_NAMEINFO_PERMANENT_ERRORS 0
41 COUNT_FORMAT_ERRORS 0
42 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
43 COUNT_ADDRINFO_PERMANENT_ERRORS 0
44 COUNT_FCRDNS_ERRORS 0
45 COUNT_HOST_ACL_ERRORS 1
46 COUNT_NO_AUTH_PLUGIN_ERRORS 0
47 COUNT_AUTH_PLUGIN_ERRORS 0
48 COUNT_HANDSHAKE_ERRORS 0
49 COUNT_PROXY_USER_ERRORS 0
50 COUNT_PROXY_USER_ACL_ERRORS 0
51 COUNT_AUTHENTICATION_ERRORS 0
52 COUNT_SSL_ERRORS 0
53 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
54 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
55 COUNT_DEFAULT_DATABASE_ERRORS 0
56 COUNT_INIT_CONNECT_ERRORS 0
57 COUNT_LOCAL_ERRORS 0
58 COUNT_UNKNOWN_ERRORS 0
59 FIRST_ERROR_SEEN set
60 LAST_ERROR_SEEN set
61 ERROR HY000: Host 'santa.claus.ipv6.example.com' is not allowed to connect to this MySQL server
62 "Dumping performance_schema.host_cache"
63 IP 2001:db8::6:6
64 HOST santa.claus.ipv6.example.com
65 HOST_VALIDATED YES
66 SUM_CONNECT_ERRORS 0
67 COUNT_HOST_BLOCKED_ERRORS 0
68 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
69 COUNT_NAMEINFO_PERMANENT_ERRORS 0
70 COUNT_FORMAT_ERRORS 0
71 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
72 COUNT_ADDRINFO_PERMANENT_ERRORS 0
73 COUNT_FCRDNS_ERRORS 0
74 COUNT_HOST_ACL_ERRORS 2
75 COUNT_NO_AUTH_PLUGIN_ERRORS 0
76 COUNT_AUTH_PLUGIN_ERRORS 0
77 COUNT_HANDSHAKE_ERRORS 0
78 COUNT_PROXY_USER_ERRORS 0
79 COUNT_PROXY_USER_ACL_ERRORS 0
80 COUNT_AUTHENTICATION_ERRORS 0
81 COUNT_SSL_ERRORS 0
82 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
83 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
84 COUNT_DEFAULT_DATABASE_ERRORS 0
85 COUNT_INIT_CONNECT_ERRORS 0
86 COUNT_LOCAL_ERRORS 0
87 COUNT_UNKNOWN_ERRORS 0
88 FIRST_ERROR_SEEN set
89 LAST_ERROR_SEEN set
90 set global debug= default;