Debian Codegraph @

mysql-test/suite/perfschema/r/hostcache_ipv6_passwd.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 create user 'user_without'@'santa.claus.ipv6.example.com';
14 create user 'user_with'@'santa.claus.ipv6.example.com'
15 identified by 'good_password';
16 grant select on test.* to 'user_without'@'santa.claus.ipv6.example.com';
17 grant select on test.* to 'user_with'@'santa.claus.ipv6.example.com';
18 connect con1,"::1",root,,test,$MASTER_MYPORT,;
19 select "Con1 is alive";
20 Con1 is alive
21 Con1 is alive
22 select current_user();
23 current_user()
24 root@localhost
25 disconnect con1;
26 connection default;
27 SET @saved_dbug = @@GLOBAL.debug_dbug;
28 set global debug_dbug= "+d,vio_peer_addr_fake_ipv6,getnameinfo_fake_ipv6,getaddrinfo_fake_good_ipv6";
29 ERROR 28000: Access denied for user 'user_without'@'santa.claus.ipv6.example.com' (using password: YES)
30 connection default;
31 # Dumping performance_schema.host_cache
32 IP 2001:db8::6:6
33 HOST santa.claus.ipv6.example.com
34 HOST_VALIDATED YES
35 SUM_CONNECT_ERRORS 0
36 COUNT_HOST_BLOCKED_ERRORS 0
37 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
38 COUNT_NAMEINFO_PERMANENT_ERRORS 0
39 COUNT_FORMAT_ERRORS 0
40 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
41 COUNT_ADDRINFO_PERMANENT_ERRORS 0
42 COUNT_FCRDNS_ERRORS 0
43 COUNT_HOST_ACL_ERRORS 0
44 COUNT_NO_AUTH_PLUGIN_ERRORS 0
45 COUNT_AUTH_PLUGIN_ERRORS 0
46 COUNT_HANDSHAKE_ERRORS 0
47 COUNT_PROXY_USER_ERRORS 0
48 COUNT_PROXY_USER_ACL_ERRORS 0
49 COUNT_AUTHENTICATION_ERRORS 1
50 COUNT_SSL_ERRORS 0
51 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
52 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
53 COUNT_DEFAULT_DATABASE_ERRORS 0
54 COUNT_INIT_CONNECT_ERRORS 0
55 COUNT_LOCAL_ERRORS 0
56 COUNT_UNKNOWN_ERRORS 0
57 FIRST_ERROR_SEEN set
58 LAST_ERROR_SEEN set
59 ERROR 28000: Access denied for user 'user_without'@'santa.claus.ipv6.example.com' (using password: YES)
60 connection default;
61 # Dumping performance_schema.host_cache
62 IP 2001:db8::6:6
63 HOST santa.claus.ipv6.example.com
64 HOST_VALIDATED YES
65 SUM_CONNECT_ERRORS 0
66 COUNT_HOST_BLOCKED_ERRORS 0
67 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
68 COUNT_NAMEINFO_PERMANENT_ERRORS 0
69 COUNT_FORMAT_ERRORS 0
70 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
71 COUNT_ADDRINFO_PERMANENT_ERRORS 0
72 COUNT_FCRDNS_ERRORS 0
73 COUNT_HOST_ACL_ERRORS 0
74 COUNT_NO_AUTH_PLUGIN_ERRORS 0
75 COUNT_AUTH_PLUGIN_ERRORS 0
76 COUNT_HANDSHAKE_ERRORS 0
77 COUNT_PROXY_USER_ERRORS 0
78 COUNT_PROXY_USER_ACL_ERRORS 0
79 COUNT_AUTHENTICATION_ERRORS 2
80 COUNT_SSL_ERRORS 0
81 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
82 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
83 COUNT_DEFAULT_DATABASE_ERRORS 0
84 COUNT_INIT_CONNECT_ERRORS 0
85 COUNT_LOCAL_ERRORS 0
86 COUNT_UNKNOWN_ERRORS 0
87 FIRST_ERROR_SEEN set
88 LAST_ERROR_SEEN set
89 ERROR 28000: Access denied for user 'user_with'@'santa.claus.ipv6.example.com' (using password: NO)
90 connection default;
91 # Dumping performance_schema.host_cache
92 IP 2001:db8::6:6
93 HOST santa.claus.ipv6.example.com
94 HOST_VALIDATED YES
95 SUM_CONNECT_ERRORS 0
96 COUNT_HOST_BLOCKED_ERRORS 0
97 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
98 COUNT_NAMEINFO_PERMANENT_ERRORS 0
99 COUNT_FORMAT_ERRORS 0
100 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
101 COUNT_ADDRINFO_PERMANENT_ERRORS 0
102 COUNT_FCRDNS_ERRORS 0
103 COUNT_HOST_ACL_ERRORS 0
104 COUNT_NO_AUTH_PLUGIN_ERRORS 0
105 COUNT_AUTH_PLUGIN_ERRORS 0
106 COUNT_HANDSHAKE_ERRORS 0
107 COUNT_PROXY_USER_ERRORS 0
108 COUNT_PROXY_USER_ACL_ERRORS 0
109 COUNT_AUTHENTICATION_ERRORS 3
110 COUNT_SSL_ERRORS 0
111 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
112 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
113 COUNT_DEFAULT_DATABASE_ERRORS 0
114 COUNT_INIT_CONNECT_ERRORS 0
115 COUNT_LOCAL_ERRORS 0
116 COUNT_UNKNOWN_ERRORS 0
117 FIRST_ERROR_SEEN set
118 LAST_ERROR_SEEN set
119 ERROR 28000: Access denied for user 'user_with'@'santa.claus.ipv6.example.com' (using password: NO)
120 connection default;
121 # Dumping performance_schema.host_cache
122 IP 2001:db8::6:6
123 HOST santa.claus.ipv6.example.com
124 HOST_VALIDATED YES
125 SUM_CONNECT_ERRORS 0
126 COUNT_HOST_BLOCKED_ERRORS 0
127 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
128 COUNT_NAMEINFO_PERMANENT_ERRORS 0
129 COUNT_FORMAT_ERRORS 0
130 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
131 COUNT_ADDRINFO_PERMANENT_ERRORS 0
132 COUNT_FCRDNS_ERRORS 0
133 COUNT_HOST_ACL_ERRORS 0
134 COUNT_NO_AUTH_PLUGIN_ERRORS 0
135 COUNT_AUTH_PLUGIN_ERRORS 0
136 COUNT_HANDSHAKE_ERRORS 0
137 COUNT_PROXY_USER_ERRORS 0
138 COUNT_PROXY_USER_ACL_ERRORS 0
139 COUNT_AUTHENTICATION_ERRORS 4
140 COUNT_SSL_ERRORS 0
141 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
142 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
143 COUNT_DEFAULT_DATABASE_ERRORS 0
144 COUNT_INIT_CONNECT_ERRORS 0
145 COUNT_LOCAL_ERRORS 0
146 COUNT_UNKNOWN_ERRORS 0
147 FIRST_ERROR_SEEN set
148 LAST_ERROR_SEEN set
149 ERROR 28000: Access denied for user 'user_with'@'santa.claus.ipv6.example.com' (using password: YES)
150 connection default;
151 # Dumping performance_schema.host_cache
152 IP 2001:db8::6:6
153 HOST santa.claus.ipv6.example.com
154 HOST_VALIDATED YES
155 SUM_CONNECT_ERRORS 0
156 COUNT_HOST_BLOCKED_ERRORS 0
157 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
158 COUNT_NAMEINFO_PERMANENT_ERRORS 0
159 COUNT_FORMAT_ERRORS 0
160 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
161 COUNT_ADDRINFO_PERMANENT_ERRORS 0
162 COUNT_FCRDNS_ERRORS 0
163 COUNT_HOST_ACL_ERRORS 0
164 COUNT_NO_AUTH_PLUGIN_ERRORS 0
165 COUNT_AUTH_PLUGIN_ERRORS 0
166 COUNT_HANDSHAKE_ERRORS 0
167 COUNT_PROXY_USER_ERRORS 0
168 COUNT_PROXY_USER_ACL_ERRORS 0
169 COUNT_AUTHENTICATION_ERRORS 5
170 COUNT_SSL_ERRORS 0
171 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
172 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
173 COUNT_DEFAULT_DATABASE_ERRORS 0
174 COUNT_INIT_CONNECT_ERRORS 0
175 COUNT_LOCAL_ERRORS 0
176 COUNT_UNKNOWN_ERRORS 0
177 FIRST_ERROR_SEEN set
178 LAST_ERROR_SEEN set
179 ERROR 28000: Access denied for user 'user_with'@'santa.claus.ipv6.example.com' (using password: YES)
180 connection default;
181 # Dumping performance_schema.host_cache
182 IP 2001:db8::6:6
183 HOST santa.claus.ipv6.example.com
184 HOST_VALIDATED YES
185 SUM_CONNECT_ERRORS 0
186 COUNT_HOST_BLOCKED_ERRORS 0
187 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
188 COUNT_NAMEINFO_PERMANENT_ERRORS 0
189 COUNT_FORMAT_ERRORS 0
190 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
191 COUNT_ADDRINFO_PERMANENT_ERRORS 0
192 COUNT_FCRDNS_ERRORS 0
193 COUNT_HOST_ACL_ERRORS 0
194 COUNT_NO_AUTH_PLUGIN_ERRORS 0
195 COUNT_AUTH_PLUGIN_ERRORS 0
196 COUNT_HANDSHAKE_ERRORS 0
197 COUNT_PROXY_USER_ERRORS 0
198 COUNT_PROXY_USER_ACL_ERRORS 0
199 COUNT_AUTHENTICATION_ERRORS 6
200 COUNT_SSL_ERRORS 0
201 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
202 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
203 COUNT_DEFAULT_DATABASE_ERRORS 0
204 COUNT_INIT_CONNECT_ERRORS 0
205 COUNT_LOCAL_ERRORS 0
206 COUNT_UNKNOWN_ERRORS 0
207 FIRST_ERROR_SEEN set
208 LAST_ERROR_SEEN set
209 drop user 'user_with'@'santa.claus.ipv6.example.com';
210 drop user 'user_without'@'santa.claus.ipv6.example.com';
211 SET @@GLOBAL.debug_dbug = @saved_dbug;