← Back to branch summary

~ubuntu-branches/ubuntu/trusty/mysql-5.6/trusty

« back to all changes in this revision

Viewing changes to mysql-test/suite/perfschema/r/hostcache_ipv4_blocked.result

  • Committer: Package Import Robot
  • Author(s): James Page
  • Date: 2014-02-12 11:54:27 UTC
  • Revision ID: package-import@ubuntu.com-20140212115427-oq6tfsqxl1wuwehi
Tags: upstream-5.6.15
Import upstream version 5.6.15

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/perfschema/r/hostcache_ipv4_blocked.result
 
1
flush status;
 
2
flush hosts;
 
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 @@global.max_connect_errors into @saved_max_connect_errors;
 
26
set global max_connect_errors = 3;
 
27
grant select on test.* to 'root'@'santa.claus.ipv4.example.com';
 
28
create user 'quota'@'santa.claus.ipv4.example.com';
 
29
grant select on test.* to 'quota'@'santa.claus.ipv4.example.com';
 
30
select "Con1 is alive";
 
31
Con1 is alive
 
32
Con1 is alive
 
33
select current_user();
 
34
current_user()
 
35
root@localhost
 
36
set global debug= "+d,vio_peer_addr_fake_ipv4,getnameinfo_fake_ipv4,getaddrinfo_fake_good_ipv4,native_password_bad_reply";
 
37
ERROR 08S01: Bad handshake
 
38
"Dumping performance_schema.host_cache"
 
39
IP      192.0.2.4
 
40
HOST    santa.claus.ipv4.example.com
 
41
HOST_VALIDATED  YES
 
42
SUM_CONNECT_ERRORS      1
 
43
COUNT_HOST_BLOCKED_ERRORS       0
 
44
COUNT_NAMEINFO_TRANSIENT_ERRORS 0
 
45
COUNT_NAMEINFO_PERMANENT_ERRORS 0
 
46
COUNT_FORMAT_ERRORS     0
 
47
COUNT_ADDRINFO_TRANSIENT_ERRORS 0
 
48
COUNT_ADDRINFO_PERMANENT_ERRORS 0
 
49
COUNT_FCRDNS_ERRORS     0
 
50
COUNT_HOST_ACL_ERRORS   0
 
51
COUNT_NO_AUTH_PLUGIN_ERRORS     0
 
52
COUNT_AUTH_PLUGIN_ERRORS        0
 
53
COUNT_HANDSHAKE_ERRORS  1
 
54
COUNT_PROXY_USER_ERRORS 0
 
55
COUNT_PROXY_USER_ACL_ERRORS     0
 
56
COUNT_AUTHENTICATION_ERRORS     0
 
57
COUNT_SSL_ERRORS        0
 
58
COUNT_MAX_USER_CONNECTIONS_ERRORS       0
 
59
COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS      0
 
60
COUNT_DEFAULT_DATABASE_ERRORS   0
 
61
COUNT_INIT_CONNECT_ERRORS       0
 
62
COUNT_LOCAL_ERRORS      0
 
63
COUNT_UNKNOWN_ERRORS    0
 
64
FIRST_ERROR_SEEN        set
 
65
LAST_ERROR_SEEN set
 
66
ERROR 08S01: Bad handshake
 
67
"Dumping performance_schema.host_cache"
 
68
IP      192.0.2.4
 
69
HOST    santa.claus.ipv4.example.com
 
70
HOST_VALIDATED  YES
 
71
SUM_CONNECT_ERRORS      2
 
72
COUNT_HOST_BLOCKED_ERRORS       0
 
73
COUNT_NAMEINFO_TRANSIENT_ERRORS 0
 
74
COUNT_NAMEINFO_PERMANENT_ERRORS 0
 
75
COUNT_FORMAT_ERRORS     0
 
76
COUNT_ADDRINFO_TRANSIENT_ERRORS 0
 
77
COUNT_ADDRINFO_PERMANENT_ERRORS 0
 
78
COUNT_FCRDNS_ERRORS     0
 
79
COUNT_HOST_ACL_ERRORS   0
 
80
COUNT_NO_AUTH_PLUGIN_ERRORS     0
 
81
COUNT_AUTH_PLUGIN_ERRORS        0
 
82
COUNT_HANDSHAKE_ERRORS  2
 
83
COUNT_PROXY_USER_ERRORS 0
 
84
COUNT_PROXY_USER_ACL_ERRORS     0
 
85
COUNT_AUTHENTICATION_ERRORS     0
 
86
COUNT_SSL_ERRORS        0
 
87
COUNT_MAX_USER_CONNECTIONS_ERRORS       0
 
88
COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS      0
 
89
COUNT_DEFAULT_DATABASE_ERRORS   0
 
90
COUNT_INIT_CONNECT_ERRORS       0
 
91
COUNT_LOCAL_ERRORS      0
 
92
COUNT_UNKNOWN_ERRORS    0
 
93
FIRST_ERROR_SEEN        set
 
94
LAST_ERROR_SEEN set
 
95
ERROR 08S01: Bad handshake
 
96
"Dumping performance_schema.host_cache"
 
97
IP      192.0.2.4
 
98
HOST    santa.claus.ipv4.example.com
 
99
HOST_VALIDATED  YES
 
100
SUM_CONNECT_ERRORS      3
 
101
COUNT_HOST_BLOCKED_ERRORS       0
 
102
COUNT_NAMEINFO_TRANSIENT_ERRORS 0
 
103
COUNT_NAMEINFO_PERMANENT_ERRORS 0
 
104
COUNT_FORMAT_ERRORS     0
 
105
COUNT_ADDRINFO_TRANSIENT_ERRORS 0
 
106
COUNT_ADDRINFO_PERMANENT_ERRORS 0
 
107
COUNT_FCRDNS_ERRORS     0
 
108
COUNT_HOST_ACL_ERRORS   0
 
109
COUNT_NO_AUTH_PLUGIN_ERRORS     0
 
110
COUNT_AUTH_PLUGIN_ERRORS        0
 
111
COUNT_HANDSHAKE_ERRORS  3
 
112
COUNT_PROXY_USER_ERRORS 0
 
113
COUNT_PROXY_USER_ACL_ERRORS     0
 
114
COUNT_AUTHENTICATION_ERRORS     0
 
115
COUNT_SSL_ERRORS        0
 
116
COUNT_MAX_USER_CONNECTIONS_ERRORS       0
 
117
COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS      0
 
118
COUNT_DEFAULT_DATABASE_ERRORS   0
 
119
COUNT_INIT_CONNECT_ERRORS       0
 
120
COUNT_LOCAL_ERRORS      0
 
121
COUNT_UNKNOWN_ERRORS    0
 
122
FIRST_ERROR_SEEN        set
 
123
LAST_ERROR_SEEN set
 
124
ERROR HY000: Host '192.0.2.4' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
 
125
"Dumping performance_schema.host_cache"
 
126
IP      192.0.2.4
 
127
HOST    santa.claus.ipv4.example.com
 
128
HOST_VALIDATED  YES
 
129
SUM_CONNECT_ERRORS      3
 
130
COUNT_HOST_BLOCKED_ERRORS       1
 
131
COUNT_NAMEINFO_TRANSIENT_ERRORS 0
 
132
COUNT_NAMEINFO_PERMANENT_ERRORS 0
 
133
COUNT_FORMAT_ERRORS     0
 
134
COUNT_ADDRINFO_TRANSIENT_ERRORS 0
 
135
COUNT_ADDRINFO_PERMANENT_ERRORS 0
 
136
COUNT_FCRDNS_ERRORS     0
 
137
COUNT_HOST_ACL_ERRORS   0
 
138
COUNT_NO_AUTH_PLUGIN_ERRORS     0
 
139
COUNT_AUTH_PLUGIN_ERRORS        0
 
140
COUNT_HANDSHAKE_ERRORS  3
 
141
COUNT_PROXY_USER_ERRORS 0
 
142
COUNT_PROXY_USER_ACL_ERRORS     0
 
143
COUNT_AUTHENTICATION_ERRORS     0
 
144
COUNT_SSL_ERRORS        0
 
145
COUNT_MAX_USER_CONNECTIONS_ERRORS       0
 
146
COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS      0
 
147
COUNT_DEFAULT_DATABASE_ERRORS   0
 
148
COUNT_INIT_CONNECT_ERRORS       0
 
149
COUNT_LOCAL_ERRORS      0
 
150
COUNT_UNKNOWN_ERRORS    0
 
151
FIRST_ERROR_SEEN        set
 
152
LAST_ERROR_SEEN set
 
153
ERROR HY000: Host '192.0.2.4' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
 
154
"Dumping performance_schema.host_cache"
 
155
IP      192.0.2.4
 
156
HOST    santa.claus.ipv4.example.com
 
157
HOST_VALIDATED  YES
 
158
SUM_CONNECT_ERRORS      3
 
159
COUNT_HOST_BLOCKED_ERRORS       2
 
160
COUNT_NAMEINFO_TRANSIENT_ERRORS 0
 
161
COUNT_NAMEINFO_PERMANENT_ERRORS 0
 
162
COUNT_FORMAT_ERRORS     0
 
163
COUNT_ADDRINFO_TRANSIENT_ERRORS 0
 
164
COUNT_ADDRINFO_PERMANENT_ERRORS 0
 
165
COUNT_FCRDNS_ERRORS     0
 
166
COUNT_HOST_ACL_ERRORS   0
 
167
COUNT_NO_AUTH_PLUGIN_ERRORS     0
 
168
COUNT_AUTH_PLUGIN_ERRORS        0
 
169
COUNT_HANDSHAKE_ERRORS  3
 
170
COUNT_PROXY_USER_ERRORS 0
 
171
COUNT_PROXY_USER_ACL_ERRORS     0
 
172
COUNT_AUTHENTICATION_ERRORS     0
 
173
COUNT_SSL_ERRORS        0
 
174
COUNT_MAX_USER_CONNECTIONS_ERRORS       0
 
175
COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS      0
 
176
COUNT_DEFAULT_DATABASE_ERRORS   0
 
177
COUNT_INIT_CONNECT_ERRORS       0
 
178
COUNT_LOCAL_ERRORS      0
 
179
COUNT_UNKNOWN_ERRORS    0
 
180
FIRST_ERROR_SEEN        set
 
181
LAST_ERROR_SEEN set
 
182
flush hosts;
 
183
ERROR 08S01: Bad handshake
 
184
"Dumping performance_schema.host_cache"
 
185
IP      192.0.2.4
 
186
HOST    santa.claus.ipv4.example.com
 
187
HOST_VALIDATED  YES
 
188
SUM_CONNECT_ERRORS      1
 
189
COUNT_HOST_BLOCKED_ERRORS       0
 
190
COUNT_NAMEINFO_TRANSIENT_ERRORS 0
 
191
COUNT_NAMEINFO_PERMANENT_ERRORS 0
 
192
COUNT_FORMAT_ERRORS     0
 
193
COUNT_ADDRINFO_TRANSIENT_ERRORS 0
 
194
COUNT_ADDRINFO_PERMANENT_ERRORS 0
 
195
COUNT_FCRDNS_ERRORS     0
 
196
COUNT_HOST_ACL_ERRORS   0
 
197
COUNT_NO_AUTH_PLUGIN_ERRORS     0
 
198
COUNT_AUTH_PLUGIN_ERRORS        0
 
199
COUNT_HANDSHAKE_ERRORS  1
 
200
COUNT_PROXY_USER_ERRORS 0
 
201
COUNT_PROXY_USER_ACL_ERRORS     0
 
202
COUNT_AUTHENTICATION_ERRORS     0
 
203
COUNT_SSL_ERRORS        0
 
204
COUNT_MAX_USER_CONNECTIONS_ERRORS       0
 
205
COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS      0
 
206
COUNT_DEFAULT_DATABASE_ERRORS   0
 
207
COUNT_INIT_CONNECT_ERRORS       0
 
208
COUNT_LOCAL_ERRORS      0
 
209
COUNT_UNKNOWN_ERRORS    0
 
210
FIRST_ERROR_SEEN        set
 
211
LAST_ERROR_SEEN set
 
212
ERROR 08S01: Bad handshake
 
213
"Dumping performance_schema.host_cache"
 
214
IP      192.0.2.4
 
215
HOST    santa.claus.ipv4.example.com
 
216
HOST_VALIDATED  YES
 
217
SUM_CONNECT_ERRORS      2
 
218
COUNT_HOST_BLOCKED_ERRORS       0
 
219
COUNT_NAMEINFO_TRANSIENT_ERRORS 0
 
220
COUNT_NAMEINFO_PERMANENT_ERRORS 0
 
221
COUNT_FORMAT_ERRORS     0
 
222
COUNT_ADDRINFO_TRANSIENT_ERRORS 0
 
223
COUNT_ADDRINFO_PERMANENT_ERRORS 0
 
224
COUNT_FCRDNS_ERRORS     0
 
225
COUNT_HOST_ACL_ERRORS   0
 
226
COUNT_NO_AUTH_PLUGIN_ERRORS     0
 
227
COUNT_AUTH_PLUGIN_ERRORS        0
 
228
COUNT_HANDSHAKE_ERRORS  2
 
229
COUNT_PROXY_USER_ERRORS 0
 
230
COUNT_PROXY_USER_ACL_ERRORS     0
 
231
COUNT_AUTHENTICATION_ERRORS     0
 
232
COUNT_SSL_ERRORS        0
 
233
COUNT_MAX_USER_CONNECTIONS_ERRORS       0
 
234
COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS      0
 
235
COUNT_DEFAULT_DATABASE_ERRORS   0
 
236
COUNT_INIT_CONNECT_ERRORS       0
 
237
COUNT_LOCAL_ERRORS      0
 
238
COUNT_UNKNOWN_ERRORS    0
 
239
FIRST_ERROR_SEEN        set
 
240
LAST_ERROR_SEEN set
 
241
set global debug= "-d,native_password_bad_reply";
 
242
message
 
243
Valid connection should reset SUM_CONNECT_ERROR counter
 
244
set global debug= "+d,native_password_bad_reply";
 
245
"Dumping performance_schema.host_cache"
 
246
IP      192.0.2.4
 
247
HOST    santa.claus.ipv4.example.com
 
248
HOST_VALIDATED  YES
 
249
SUM_CONNECT_ERRORS      0
 
250
COUNT_HOST_BLOCKED_ERRORS       0
 
251
COUNT_NAMEINFO_TRANSIENT_ERRORS 0
 
252
COUNT_NAMEINFO_PERMANENT_ERRORS 0
 
253
COUNT_FORMAT_ERRORS     0
 
254
COUNT_ADDRINFO_TRANSIENT_ERRORS 0
 
255
COUNT_ADDRINFO_PERMANENT_ERRORS 0
 
256
COUNT_FCRDNS_ERRORS     0
 
257
COUNT_HOST_ACL_ERRORS   0
 
258
COUNT_NO_AUTH_PLUGIN_ERRORS     0
 
259
COUNT_AUTH_PLUGIN_ERRORS        0
 
260
COUNT_HANDSHAKE_ERRORS  2
 
261
COUNT_PROXY_USER_ERRORS 0
 
262
COUNT_PROXY_USER_ACL_ERRORS     0
 
263
COUNT_AUTHENTICATION_ERRORS     0
 
264
COUNT_SSL_ERRORS        0
 
265
COUNT_MAX_USER_CONNECTIONS_ERRORS       0
 
266
COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS      0
 
267
COUNT_DEFAULT_DATABASE_ERRORS   0
 
268
COUNT_INIT_CONNECT_ERRORS       0
 
269
COUNT_LOCAL_ERRORS      0
 
270
COUNT_UNKNOWN_ERRORS    0
 
271
FIRST_ERROR_SEEN        set
 
272
LAST_ERROR_SEEN set
 
273
ERROR 08S01: Bad handshake
 
274
"Dumping performance_schema.host_cache"
 
275
IP      192.0.2.4
 
276
HOST    santa.claus.ipv4.example.com
 
277
HOST_VALIDATED  YES
 
278
SUM_CONNECT_ERRORS      1
 
279
COUNT_HOST_BLOCKED_ERRORS       0
 
280
COUNT_NAMEINFO_TRANSIENT_ERRORS 0
 
281
COUNT_NAMEINFO_PERMANENT_ERRORS 0
 
282
COUNT_FORMAT_ERRORS     0
 
283
COUNT_ADDRINFO_TRANSIENT_ERRORS 0
 
284
COUNT_ADDRINFO_PERMANENT_ERRORS 0
 
285
COUNT_FCRDNS_ERRORS     0
 
286
COUNT_HOST_ACL_ERRORS   0
 
287
COUNT_NO_AUTH_PLUGIN_ERRORS     0
 
288
COUNT_AUTH_PLUGIN_ERRORS        0
 
289
COUNT_HANDSHAKE_ERRORS  3
 
290
COUNT_PROXY_USER_ERRORS 0
 
291
COUNT_PROXY_USER_ACL_ERRORS     0
 
292
COUNT_AUTHENTICATION_ERRORS     0
 
293
COUNT_SSL_ERRORS        0
 
294
COUNT_MAX_USER_CONNECTIONS_ERRORS       0
 
295
COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS      0
 
296
COUNT_DEFAULT_DATABASE_ERRORS   0
 
297
COUNT_INIT_CONNECT_ERRORS       0
 
298
COUNT_LOCAL_ERRORS      0
 
299
COUNT_UNKNOWN_ERRORS    0
 
300
FIRST_ERROR_SEEN        set
 
301
LAST_ERROR_SEEN set
 
302
ERROR 08S01: Bad handshake
 
303
"Dumping performance_schema.host_cache"
 
304
IP      192.0.2.4
 
305
HOST    santa.claus.ipv4.example.com
 
306
HOST_VALIDATED  YES
 
307
SUM_CONNECT_ERRORS      2
 
308
COUNT_HOST_BLOCKED_ERRORS       0
 
309
COUNT_NAMEINFO_TRANSIENT_ERRORS 0
 
310
COUNT_NAMEINFO_PERMANENT_ERRORS 0
 
311
COUNT_FORMAT_ERRORS     0
 
312
COUNT_ADDRINFO_TRANSIENT_ERRORS 0
 
313
COUNT_ADDRINFO_PERMANENT_ERRORS 0
 
314
COUNT_FCRDNS_ERRORS     0
 
315
COUNT_HOST_ACL_ERRORS   0
 
316
COUNT_NO_AUTH_PLUGIN_ERRORS     0
 
317
COUNT_AUTH_PLUGIN_ERRORS        0
 
318
COUNT_HANDSHAKE_ERRORS  4
 
319
COUNT_PROXY_USER_ERRORS 0
 
320
COUNT_PROXY_USER_ACL_ERRORS     0
 
321
COUNT_AUTHENTICATION_ERRORS     0
 
322
COUNT_SSL_ERRORS        0
 
323
COUNT_MAX_USER_CONNECTIONS_ERRORS       0
 
324
COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS      0
 
325
COUNT_DEFAULT_DATABASE_ERRORS   0
 
326
COUNT_INIT_CONNECT_ERRORS       0
 
327
COUNT_LOCAL_ERRORS      0
 
328
COUNT_UNKNOWN_ERRORS    0
 
329
FIRST_ERROR_SEEN        set
 
330
LAST_ERROR_SEEN set
 
331
ERROR 08S01: Bad handshake
 
332
"Dumping performance_schema.host_cache"
 
333
IP      192.0.2.4
 
334
HOST    santa.claus.ipv4.example.com
 
335
HOST_VALIDATED  YES
 
336
SUM_CONNECT_ERRORS      3
 
337
COUNT_HOST_BLOCKED_ERRORS       0
 
338
COUNT_NAMEINFO_TRANSIENT_ERRORS 0
 
339
COUNT_NAMEINFO_PERMANENT_ERRORS 0
 
340
COUNT_FORMAT_ERRORS     0
 
341
COUNT_ADDRINFO_TRANSIENT_ERRORS 0
 
342
COUNT_ADDRINFO_PERMANENT_ERRORS 0
 
343
COUNT_FCRDNS_ERRORS     0
 
344
COUNT_HOST_ACL_ERRORS   0
 
345
COUNT_NO_AUTH_PLUGIN_ERRORS     0
 
346
COUNT_AUTH_PLUGIN_ERRORS        0
 
347
COUNT_HANDSHAKE_ERRORS  5
 
348
COUNT_PROXY_USER_ERRORS 0
 
349
COUNT_PROXY_USER_ACL_ERRORS     0
 
350
COUNT_AUTHENTICATION_ERRORS     0
 
351
COUNT_SSL_ERRORS        0
 
352
COUNT_MAX_USER_CONNECTIONS_ERRORS       0
 
353
COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS      0
 
354
COUNT_DEFAULT_DATABASE_ERRORS   0
 
355
COUNT_INIT_CONNECT_ERRORS       0
 
356
COUNT_LOCAL_ERRORS      0
 
357
COUNT_UNKNOWN_ERRORS    0
 
358
FIRST_ERROR_SEEN        set
 
359
LAST_ERROR_SEEN set
 
360
ERROR HY000: Host '192.0.2.4' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
 
361
"Dumping performance_schema.host_cache"
 
362
IP      192.0.2.4
 
363
HOST    santa.claus.ipv4.example.com
 
364
HOST_VALIDATED  YES
 
365
SUM_CONNECT_ERRORS      3
 
366
COUNT_HOST_BLOCKED_ERRORS       1
 
367
COUNT_NAMEINFO_TRANSIENT_ERRORS 0
 
368
COUNT_NAMEINFO_PERMANENT_ERRORS 0
 
369
COUNT_FORMAT_ERRORS     0
 
370
COUNT_ADDRINFO_TRANSIENT_ERRORS 0
 
371
COUNT_ADDRINFO_PERMANENT_ERRORS 0
 
372
COUNT_FCRDNS_ERRORS     0
 
373
COUNT_HOST_ACL_ERRORS   0
 
374
COUNT_NO_AUTH_PLUGIN_ERRORS     0
 
375
COUNT_AUTH_PLUGIN_ERRORS        0
 
376
COUNT_HANDSHAKE_ERRORS  5
 
377
COUNT_PROXY_USER_ERRORS 0
 
378
COUNT_PROXY_USER_ACL_ERRORS     0
 
379
COUNT_AUTHENTICATION_ERRORS     0
 
380
COUNT_SSL_ERRORS        0
 
381
COUNT_MAX_USER_CONNECTIONS_ERRORS       0
 
382
COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS      0
 
383
COUNT_DEFAULT_DATABASE_ERRORS   0
 
384
COUNT_INIT_CONNECT_ERRORS       0
 
385
COUNT_LOCAL_ERRORS      0
 
386
COUNT_UNKNOWN_ERRORS    0
 
387
FIRST_ERROR_SEEN        set
 
388
LAST_ERROR_SEEN set
 
389
ERROR HY000: Host '192.0.2.4' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
 
390
"Dumping performance_schema.host_cache"
 
391
IP      192.0.2.4
 
392
HOST    santa.claus.ipv4.example.com
 
393
HOST_VALIDATED  YES
 
394
SUM_CONNECT_ERRORS      3
 
395
COUNT_HOST_BLOCKED_ERRORS       2
 
396
COUNT_NAMEINFO_TRANSIENT_ERRORS 0
 
397
COUNT_NAMEINFO_PERMANENT_ERRORS 0
 
398
COUNT_FORMAT_ERRORS     0
 
399
COUNT_ADDRINFO_TRANSIENT_ERRORS 0
 
400
COUNT_ADDRINFO_PERMANENT_ERRORS 0
 
401
COUNT_FCRDNS_ERRORS     0
 
402
COUNT_HOST_ACL_ERRORS   0
 
403
COUNT_NO_AUTH_PLUGIN_ERRORS     0
 
404
COUNT_AUTH_PLUGIN_ERRORS        0
 
405
COUNT_HANDSHAKE_ERRORS  5
 
406
COUNT_PROXY_USER_ERRORS 0
 
407
COUNT_PROXY_USER_ACL_ERRORS     0
 
408
COUNT_AUTHENTICATION_ERRORS     0
 
409
COUNT_SSL_ERRORS        0
 
410
COUNT_MAX_USER_CONNECTIONS_ERRORS       0
 
411
COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS      0
 
412
COUNT_DEFAULT_DATABASE_ERRORS   0
 
413
COUNT_INIT_CONNECT_ERRORS       0
 
414
COUNT_LOCAL_ERRORS      0
 
415
COUNT_UNKNOWN_ERRORS    0
 
416
FIRST_ERROR_SEEN        set
 
417
LAST_ERROR_SEEN set
 
418
revoke select on test.* from 'root'@'santa.claus.ipv4.example.com';
 
419
drop user 'root'@'santa.claus.ipv4.example.com';
 
420
revoke select on test.* from 'quota'@'santa.claus.ipv4.example.com';
 
421
drop user 'quota'@'santa.claus.ipv4.example.com';
 
422
set global max_connect_errors = @saved_max_connect_errors;
 
423
set global debug= default;