flush status;
flush hosts;
flush user_resources;
flush privileges;
select `User`, `Host` from mysql.`user` where `host` like '%\\%%';
User	Host
select `User`, `Host` from mysql.`user` where `user` like '192.%';
User	Host
select `User`, `Host` from mysql.`user` where `user` like '2001:%';
User	Host
select `User`, `Host` from mysql.`user` where `user` like 'santa.claus.%';
User	Host
select @@global.max_connect_errors into @saved_max_connect_errors;
set global max_connect_errors = 3;
create user 'root'@'santa.claus.ipv6.example.com';
grant select on test.* to 'root'@'santa.claus.ipv6.example.com';
create user 'quota'@'santa.claus.ipv6.example.com';
grant select on test.* to 'quota'@'santa.claus.ipv6.example.com';
connect  con1,"::1",root,,test,$MASTER_MYPORT,;
select "Con1 is alive";
Con1 is alive
Con1 is alive
select current_user();
current_user()
root@localhost
disconnect con1;
connection default;
SET @saved_dbug = @@GLOBAL.debug_dbug;
set global debug_dbug= "+d,vio_peer_addr_fake_ipv6,getnameinfo_fake_ipv6,getaddrinfo_fake_good_ipv6,native_password_bad_reply";
ERROR 08S01: Bad handshake
connection default;
# Dumping performance_schema.host_cache
IP	2001:db8::6:6
HOST	santa.claus.ipv6.example.com
HOST_VALIDATED	YES
SUM_CONNECT_ERRORS	1
COUNT_HOST_BLOCKED_ERRORS	0
COUNT_NAMEINFO_TRANSIENT_ERRORS	0
COUNT_NAMEINFO_PERMANENT_ERRORS	0
COUNT_FORMAT_ERRORS	0
COUNT_ADDRINFO_TRANSIENT_ERRORS	0
COUNT_ADDRINFO_PERMANENT_ERRORS	0
COUNT_FCRDNS_ERRORS	0
COUNT_HOST_ACL_ERRORS	0
COUNT_NO_AUTH_PLUGIN_ERRORS	0
COUNT_AUTH_PLUGIN_ERRORS	0
COUNT_HANDSHAKE_ERRORS	1
COUNT_PROXY_USER_ERRORS	0
COUNT_PROXY_USER_ACL_ERRORS	0
COUNT_AUTHENTICATION_ERRORS	0
COUNT_SSL_ERRORS	0
COUNT_MAX_USER_CONNECTIONS_ERRORS	0
COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS	0
COUNT_DEFAULT_DATABASE_ERRORS	0
COUNT_INIT_CONNECT_ERRORS	0
COUNT_LOCAL_ERRORS	0
COUNT_UNKNOWN_ERRORS	0
FIRST_ERROR_SEEN	set
LAST_ERROR_SEEN	set
ERROR 08S01: Bad handshake
connection default;
# Dumping performance_schema.host_cache
IP	2001:db8::6:6
HOST	santa.claus.ipv6.example.com
HOST_VALIDATED	YES
SUM_CONNECT_ERRORS	2
COUNT_HOST_BLOCKED_ERRORS	0
COUNT_NAMEINFO_TRANSIENT_ERRORS	0
COUNT_NAMEINFO_PERMANENT_ERRORS	0
COUNT_FORMAT_ERRORS	0
COUNT_ADDRINFO_TRANSIENT_ERRORS	0
COUNT_ADDRINFO_PERMANENT_ERRORS	0
COUNT_FCRDNS_ERRORS	0
COUNT_HOST_ACL_ERRORS	0
COUNT_NO_AUTH_PLUGIN_ERRORS	0
COUNT_AUTH_PLUGIN_ERRORS	0
COUNT_HANDSHAKE_ERRORS	2
COUNT_PROXY_USER_ERRORS	0
COUNT_PROXY_USER_ACL_ERRORS	0
COUNT_AUTHENTICATION_ERRORS	0
COUNT_SSL_ERRORS	0
COUNT_MAX_USER_CONNECTIONS_ERRORS	0
COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS	0
COUNT_DEFAULT_DATABASE_ERRORS	0
COUNT_INIT_CONNECT_ERRORS	0
COUNT_LOCAL_ERRORS	0
COUNT_UNKNOWN_ERRORS	0
FIRST_ERROR_SEEN	set
LAST_ERROR_SEEN	set
ERROR 08S01: Bad handshake
connection default;
# Dumping performance_schema.host_cache
IP	2001:db8::6:6
HOST	santa.claus.ipv6.example.com
HOST_VALIDATED	YES
SUM_CONNECT_ERRORS	3
COUNT_HOST_BLOCKED_ERRORS	0
COUNT_NAMEINFO_TRANSIENT_ERRORS	0
COUNT_NAMEINFO_PERMANENT_ERRORS	0
COUNT_FORMAT_ERRORS	0
COUNT_ADDRINFO_TRANSIENT_ERRORS	0
COUNT_ADDRINFO_PERMANENT_ERRORS	0
COUNT_FCRDNS_ERRORS	0
COUNT_HOST_ACL_ERRORS	0
COUNT_NO_AUTH_PLUGIN_ERRORS	0
COUNT_AUTH_PLUGIN_ERRORS	0
COUNT_HANDSHAKE_ERRORS	3
COUNT_PROXY_USER_ERRORS	0
COUNT_PROXY_USER_ACL_ERRORS	0
COUNT_AUTHENTICATION_ERRORS	0
COUNT_SSL_ERRORS	0
COUNT_MAX_USER_CONNECTIONS_ERRORS	0
COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS	0
COUNT_DEFAULT_DATABASE_ERRORS	0
COUNT_INIT_CONNECT_ERRORS	0
COUNT_LOCAL_ERRORS	0
COUNT_UNKNOWN_ERRORS	0
FIRST_ERROR_SEEN	set
LAST_ERROR_SEEN	set
ERROR HY000: Host '2001:db8::6:6' is blocked because of many connection errors; unblock with 'mariadb-admin flush-hosts'
connection default;
# Dumping performance_schema.host_cache
IP	2001:db8::6:6
HOST	santa.claus.ipv6.example.com
HOST_VALIDATED	YES
SUM_CONNECT_ERRORS	3
COUNT_HOST_BLOCKED_ERRORS	1
COUNT_NAMEINFO_TRANSIENT_ERRORS	0
COUNT_NAMEINFO_PERMANENT_ERRORS	0
COUNT_FORMAT_ERRORS	0
COUNT_ADDRINFO_TRANSIENT_ERRORS	0
COUNT_ADDRINFO_PERMANENT_ERRORS	0
COUNT_FCRDNS_ERRORS	0
COUNT_HOST_ACL_ERRORS	0
COUNT_NO_AUTH_PLUGIN_ERRORS	0
COUNT_AUTH_PLUGIN_ERRORS	0
COUNT_HANDSHAKE_ERRORS	3
COUNT_PROXY_USER_ERRORS	0
COUNT_PROXY_USER_ACL_ERRORS	0
COUNT_AUTHENTICATION_ERRORS	0
COUNT_SSL_ERRORS	0
COUNT_MAX_USER_CONNECTIONS_ERRORS	0
COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS	0
COUNT_DEFAULT_DATABASE_ERRORS	0
COUNT_INIT_CONNECT_ERRORS	0
COUNT_LOCAL_ERRORS	0
COUNT_UNKNOWN_ERRORS	0
FIRST_ERROR_SEEN	set
LAST_ERROR_SEEN	set
ERROR HY000: Host '2001:db8::6:6' is blocked because of many connection errors; unblock with 'mariadb-admin flush-hosts'
connection default;
# Dumping performance_schema.host_cache
IP	2001:db8::6:6
HOST	santa.claus.ipv6.example.com
HOST_VALIDATED	YES
SUM_CONNECT_ERRORS	3
COUNT_HOST_BLOCKED_ERRORS	2
COUNT_NAMEINFO_TRANSIENT_ERRORS	0
COUNT_NAMEINFO_PERMANENT_ERRORS	0
COUNT_FORMAT_ERRORS	0
COUNT_ADDRINFO_TRANSIENT_ERRORS	0
COUNT_ADDRINFO_PERMANENT_ERRORS	0
COUNT_FCRDNS_ERRORS	0
COUNT_HOST_ACL_ERRORS	0
COUNT_NO_AUTH_PLUGIN_ERRORS	0
COUNT_AUTH_PLUGIN_ERRORS	0
COUNT_HANDSHAKE_ERRORS	3
COUNT_PROXY_USER_ERRORS	0
COUNT_PROXY_USER_ACL_ERRORS	0
COUNT_AUTHENTICATION_ERRORS	0
COUNT_SSL_ERRORS	0
COUNT_MAX_USER_CONNECTIONS_ERRORS	0
COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS	0
COUNT_DEFAULT_DATABASE_ERRORS	0
COUNT_INIT_CONNECT_ERRORS	0
COUNT_LOCAL_ERRORS	0
COUNT_UNKNOWN_ERRORS	0
FIRST_ERROR_SEEN	set
LAST_ERROR_SEEN	set
flush hosts;
ERROR 08S01: Bad handshake
connection default;
# Dumping performance_schema.host_cache
IP	2001:db8::6:6
HOST	santa.claus.ipv6.example.com
HOST_VALIDATED	YES
SUM_CONNECT_ERRORS	1
COUNT_HOST_BLOCKED_ERRORS	0
COUNT_NAMEINFO_TRANSIENT_ERRORS	0
COUNT_NAMEINFO_PERMANENT_ERRORS	0
COUNT_FORMAT_ERRORS	0
COUNT_ADDRINFO_TRANSIENT_ERRORS	0
COUNT_ADDRINFO_PERMANENT_ERRORS	0
COUNT_FCRDNS_ERRORS	0
COUNT_HOST_ACL_ERRORS	0
COUNT_NO_AUTH_PLUGIN_ERRORS	0
COUNT_AUTH_PLUGIN_ERRORS	0
COUNT_HANDSHAKE_ERRORS	1
COUNT_PROXY_USER_ERRORS	0
COUNT_PROXY_USER_ACL_ERRORS	0
COUNT_AUTHENTICATION_ERRORS	0
COUNT_SSL_ERRORS	0
COUNT_MAX_USER_CONNECTIONS_ERRORS	0
COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS	0
COUNT_DEFAULT_DATABASE_ERRORS	0
COUNT_INIT_CONNECT_ERRORS	0
COUNT_LOCAL_ERRORS	0
COUNT_UNKNOWN_ERRORS	0
FIRST_ERROR_SEEN	set
LAST_ERROR_SEEN	set
ERROR 08S01: Bad handshake
connection default;
# Dumping performance_schema.host_cache
IP	2001:db8::6:6
HOST	santa.claus.ipv6.example.com
HOST_VALIDATED	YES
SUM_CONNECT_ERRORS	2
COUNT_HOST_BLOCKED_ERRORS	0
COUNT_NAMEINFO_TRANSIENT_ERRORS	0
COUNT_NAMEINFO_PERMANENT_ERRORS	0
COUNT_FORMAT_ERRORS	0
COUNT_ADDRINFO_TRANSIENT_ERRORS	0
COUNT_ADDRINFO_PERMANENT_ERRORS	0
COUNT_FCRDNS_ERRORS	0
COUNT_HOST_ACL_ERRORS	0
COUNT_NO_AUTH_PLUGIN_ERRORS	0
COUNT_AUTH_PLUGIN_ERRORS	0
COUNT_HANDSHAKE_ERRORS	2
COUNT_PROXY_USER_ERRORS	0
COUNT_PROXY_USER_ACL_ERRORS	0
COUNT_AUTHENTICATION_ERRORS	0
COUNT_SSL_ERRORS	0
COUNT_MAX_USER_CONNECTIONS_ERRORS	0
COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS	0
COUNT_DEFAULT_DATABASE_ERRORS	0
COUNT_INIT_CONNECT_ERRORS	0
COUNT_LOCAL_ERRORS	0
COUNT_UNKNOWN_ERRORS	0
FIRST_ERROR_SEEN	set
LAST_ERROR_SEEN	set
connection default;
set global debug_dbug= "-d,native_password_bad_reply";
message
Valid connection should reset SUM_CONNECT_ERROR counter
connection default;
set global debug_dbug= "+d,native_password_bad_reply";
connection default;
# Dumping performance_schema.host_cache
IP	2001:db8::6:6
HOST	santa.claus.ipv6.example.com
HOST_VALIDATED	YES
SUM_CONNECT_ERRORS	0
COUNT_HOST_BLOCKED_ERRORS	0
COUNT_NAMEINFO_TRANSIENT_ERRORS	0
COUNT_NAMEINFO_PERMANENT_ERRORS	0
COUNT_FORMAT_ERRORS	0
COUNT_ADDRINFO_TRANSIENT_ERRORS	0
COUNT_ADDRINFO_PERMANENT_ERRORS	0
COUNT_FCRDNS_ERRORS	0
COUNT_HOST_ACL_ERRORS	0
COUNT_NO_AUTH_PLUGIN_ERRORS	0
COUNT_AUTH_PLUGIN_ERRORS	0
COUNT_HANDSHAKE_ERRORS	2
COUNT_PROXY_USER_ERRORS	0
COUNT_PROXY_USER_ACL_ERRORS	0
COUNT_AUTHENTICATION_ERRORS	0
COUNT_SSL_ERRORS	0
COUNT_MAX_USER_CONNECTIONS_ERRORS	0
COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS	0
COUNT_DEFAULT_DATABASE_ERRORS	0
COUNT_INIT_CONNECT_ERRORS	0
COUNT_LOCAL_ERRORS	0
COUNT_UNKNOWN_ERRORS	0
FIRST_ERROR_SEEN	set
LAST_ERROR_SEEN	set
ERROR 08S01: Bad handshake
connection default;
# Dumping performance_schema.host_cache
IP	2001:db8::6:6
HOST	santa.claus.ipv6.example.com
HOST_VALIDATED	YES
SUM_CONNECT_ERRORS	1
COUNT_HOST_BLOCKED_ERRORS	0
COUNT_NAMEINFO_TRANSIENT_ERRORS	0
COUNT_NAMEINFO_PERMANENT_ERRORS	0
COUNT_FORMAT_ERRORS	0
COUNT_ADDRINFO_TRANSIENT_ERRORS	0
COUNT_ADDRINFO_PERMANENT_ERRORS	0
COUNT_FCRDNS_ERRORS	0
COUNT_HOST_ACL_ERRORS	0
COUNT_NO_AUTH_PLUGIN_ERRORS	0
COUNT_AUTH_PLUGIN_ERRORS	0
COUNT_HANDSHAKE_ERRORS	3
COUNT_PROXY_USER_ERRORS	0
COUNT_PROXY_USER_ACL_ERRORS	0
COUNT_AUTHENTICATION_ERRORS	0
COUNT_SSL_ERRORS	0
COUNT_MAX_USER_CONNECTIONS_ERRORS	0
COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS	0
COUNT_DEFAULT_DATABASE_ERRORS	0
COUNT_INIT_CONNECT_ERRORS	0
COUNT_LOCAL_ERRORS	0
COUNT_UNKNOWN_ERRORS	0
FIRST_ERROR_SEEN	set
LAST_ERROR_SEEN	set
ERROR 08S01: Bad handshake
connection default;
# Dumping performance_schema.host_cache
IP	2001:db8::6:6
HOST	santa.claus.ipv6.example.com
HOST_VALIDATED	YES
SUM_CONNECT_ERRORS	2
COUNT_HOST_BLOCKED_ERRORS	0
COUNT_NAMEINFO_TRANSIENT_ERRORS	0
COUNT_NAMEINFO_PERMANENT_ERRORS	0
COUNT_FORMAT_ERRORS	0
COUNT_ADDRINFO_TRANSIENT_ERRORS	0
COUNT_ADDRINFO_PERMANENT_ERRORS	0
COUNT_FCRDNS_ERRORS	0
COUNT_HOST_ACL_ERRORS	0
COUNT_NO_AUTH_PLUGIN_ERRORS	0
COUNT_AUTH_PLUGIN_ERRORS	0
COUNT_HANDSHAKE_ERRORS	4
COUNT_PROXY_USER_ERRORS	0
COUNT_PROXY_USER_ACL_ERRORS	0
COUNT_AUTHENTICATION_ERRORS	0
COUNT_SSL_ERRORS	0
COUNT_MAX_USER_CONNECTIONS_ERRORS	0
COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS	0
COUNT_DEFAULT_DATABASE_ERRORS	0
COUNT_INIT_CONNECT_ERRORS	0
COUNT_LOCAL_ERRORS	0
COUNT_UNKNOWN_ERRORS	0
FIRST_ERROR_SEEN	set
LAST_ERROR_SEEN	set
ERROR 08S01: Bad handshake
connection default;
# Dumping performance_schema.host_cache
IP	2001:db8::6:6
HOST	santa.claus.ipv6.example.com
HOST_VALIDATED	YES
SUM_CONNECT_ERRORS	3
COUNT_HOST_BLOCKED_ERRORS	0
COUNT_NAMEINFO_TRANSIENT_ERRORS	0
COUNT_NAMEINFO_PERMANENT_ERRORS	0
COUNT_FORMAT_ERRORS	0
COUNT_ADDRINFO_TRANSIENT_ERRORS	0
COUNT_ADDRINFO_PERMANENT_ERRORS	0
COUNT_FCRDNS_ERRORS	0
COUNT_HOST_ACL_ERRORS	0
COUNT_NO_AUTH_PLUGIN_ERRORS	0
COUNT_AUTH_PLUGIN_ERRORS	0
COUNT_HANDSHAKE_ERRORS	5
COUNT_PROXY_USER_ERRORS	0
COUNT_PROXY_USER_ACL_ERRORS	0
COUNT_AUTHENTICATION_ERRORS	0
COUNT_SSL_ERRORS	0
COUNT_MAX_USER_CONNECTIONS_ERRORS	0
COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS	0
COUNT_DEFAULT_DATABASE_ERRORS	0
COUNT_INIT_CONNECT_ERRORS	0
COUNT_LOCAL_ERRORS	0
COUNT_UNKNOWN_ERRORS	0
FIRST_ERROR_SEEN	set
LAST_ERROR_SEEN	set
ERROR HY000: Host '2001:db8::6:6' is blocked because of many connection errors; unblock with 'mariadb-admin flush-hosts'
connection default;
# Dumping performance_schema.host_cache
IP	2001:db8::6:6
HOST	santa.claus.ipv6.example.com
HOST_VALIDATED	YES
SUM_CONNECT_ERRORS	3
COUNT_HOST_BLOCKED_ERRORS	1
COUNT_NAMEINFO_TRANSIENT_ERRORS	0
COUNT_NAMEINFO_PERMANENT_ERRORS	0
COUNT_FORMAT_ERRORS	0
COUNT_ADDRINFO_TRANSIENT_ERRORS	0
COUNT_ADDRINFO_PERMANENT_ERRORS	0
COUNT_FCRDNS_ERRORS	0
COUNT_HOST_ACL_ERRORS	0
COUNT_NO_AUTH_PLUGIN_ERRORS	0
COUNT_AUTH_PLUGIN_ERRORS	0
COUNT_HANDSHAKE_ERRORS	5
COUNT_PROXY_USER_ERRORS	0
COUNT_PROXY_USER_ACL_ERRORS	0
COUNT_AUTHENTICATION_ERRORS	0
COUNT_SSL_ERRORS	0
COUNT_MAX_USER_CONNECTIONS_ERRORS	0
COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS	0
COUNT_DEFAULT_DATABASE_ERRORS	0
COUNT_INIT_CONNECT_ERRORS	0
COUNT_LOCAL_ERRORS	0
COUNT_UNKNOWN_ERRORS	0
FIRST_ERROR_SEEN	set
LAST_ERROR_SEEN	set
ERROR HY000: Host '2001:db8::6:6' is blocked because of many connection errors; unblock with 'mariadb-admin flush-hosts'
connection default;
# Dumping performance_schema.host_cache
IP	2001:db8::6:6
HOST	santa.claus.ipv6.example.com
HOST_VALIDATED	YES
SUM_CONNECT_ERRORS	3
COUNT_HOST_BLOCKED_ERRORS	2
COUNT_NAMEINFO_TRANSIENT_ERRORS	0
COUNT_NAMEINFO_PERMANENT_ERRORS	0
COUNT_FORMAT_ERRORS	0
COUNT_ADDRINFO_TRANSIENT_ERRORS	0
COUNT_ADDRINFO_PERMANENT_ERRORS	0
COUNT_FCRDNS_ERRORS	0
COUNT_HOST_ACL_ERRORS	0
COUNT_NO_AUTH_PLUGIN_ERRORS	0
COUNT_AUTH_PLUGIN_ERRORS	0
COUNT_HANDSHAKE_ERRORS	5
COUNT_PROXY_USER_ERRORS	0
COUNT_PROXY_USER_ACL_ERRORS	0
COUNT_AUTHENTICATION_ERRORS	0
COUNT_SSL_ERRORS	0
COUNT_MAX_USER_CONNECTIONS_ERRORS	0
COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS	0
COUNT_DEFAULT_DATABASE_ERRORS	0
COUNT_INIT_CONNECT_ERRORS	0
COUNT_LOCAL_ERRORS	0
COUNT_UNKNOWN_ERRORS	0
FIRST_ERROR_SEEN	set
LAST_ERROR_SEEN	set
revoke select on test.* from 'root'@'santa.claus.ipv6.example.com';
drop user 'root'@'santa.claus.ipv6.example.com';
revoke select on test.* from 'quota'@'santa.claus.ipv6.example.com';
drop user 'quota'@'santa.claus.ipv6.example.com';
set global max_connect_errors = @saved_max_connect_errors;
SET @@GLOBAL.debug_dbug = @saved_dbug;