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 26grant select on test.* to 'root'@'192.0.2.4'; 27select "Con1 is alive"; 28Con1 is alive 29Con1 is alive 30select current_user(); 31current_user() 32root@localhost 33set global debug= "+d,vio_peer_addr_fake_ipv4,getnameinfo_fake_ipv4,getaddrinfo_fake_bad_ipv4"; 34select "Con2 is alive"; 35Con2 is alive 36Con2 is alive 37select current_user(); 38current_user() 39root@192.0.2.4 40"Dumping performance_schema.host_cache" 41IP 192.0.2.4 42HOST NULL 43HOST_VALIDATED YES 44SUM_CONNECT_ERRORS 0 45COUNT_HOST_BLOCKED_ERRORS 0 46COUNT_NAMEINFO_TRANSIENT_ERRORS 0 47COUNT_NAMEINFO_PERMANENT_ERRORS 0 48COUNT_FORMAT_ERRORS 0 49COUNT_ADDRINFO_TRANSIENT_ERRORS 0 50COUNT_ADDRINFO_PERMANENT_ERRORS 0 51COUNT_FCRDNS_ERRORS 1 52COUNT_HOST_ACL_ERRORS 0 53COUNT_NO_AUTH_PLUGIN_ERRORS 0 54COUNT_AUTH_PLUGIN_ERRORS 0 55COUNT_HANDSHAKE_ERRORS 0 56COUNT_PROXY_USER_ERRORS 0 57COUNT_PROXY_USER_ACL_ERRORS 0 58COUNT_AUTHENTICATION_ERRORS 0 59COUNT_SSL_ERRORS 0 60COUNT_MAX_USER_CONNECTIONS_ERRORS 0 61COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0 62COUNT_DEFAULT_DATABASE_ERRORS 0 63COUNT_INIT_CONNECT_ERRORS 0 64COUNT_LOCAL_ERRORS 0 65COUNT_UNKNOWN_ERRORS 0 66FIRST_ERROR_SEEN set 67LAST_ERROR_SEEN set 68select "Con3 is alive"; 69Con3 is alive 70Con3 is alive 71select current_user(); 72current_user() 73root@192.0.2.4 74"Dumping performance_schema.host_cache" 75IP 192.0.2.4 76HOST NULL 77HOST_VALIDATED YES 78SUM_CONNECT_ERRORS 0 79COUNT_HOST_BLOCKED_ERRORS 0 80COUNT_NAMEINFO_TRANSIENT_ERRORS 0 81COUNT_NAMEINFO_PERMANENT_ERRORS 0 82COUNT_FORMAT_ERRORS 0 83COUNT_ADDRINFO_TRANSIENT_ERRORS 0 84COUNT_ADDRINFO_PERMANENT_ERRORS 0 85COUNT_FCRDNS_ERRORS 1 86COUNT_HOST_ACL_ERRORS 0 87COUNT_NO_AUTH_PLUGIN_ERRORS 0 88COUNT_AUTH_PLUGIN_ERRORS 0 89COUNT_HANDSHAKE_ERRORS 0 90COUNT_PROXY_USER_ERRORS 0 91COUNT_PROXY_USER_ACL_ERRORS 0 92COUNT_AUTHENTICATION_ERRORS 0 93COUNT_SSL_ERRORS 0 94COUNT_MAX_USER_CONNECTIONS_ERRORS 0 95COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0 96COUNT_DEFAULT_DATABASE_ERRORS 0 97COUNT_INIT_CONNECT_ERRORS 0 98COUNT_LOCAL_ERRORS 0 99COUNT_UNKNOWN_ERRORS 0 100FIRST_ERROR_SEEN set 101LAST_ERROR_SEEN set 102revoke select on test.* from 'root'@'192.0.2.4'; 103drop user 'root'@'192.0.2.4'; 104set global debug= default; 105