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