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 CREATE USER 'plug'@'santa.claus.ipv4.example.com' IDENTIFIED WITH 'test_plugin_server' AS 'plug_dest'; CREATE USER 'plug_dest'@'santa.claus.ipv4.example.com' IDENTIFIED BY 'plug_test_passwd'; GRANT SELECT ON test.* TO 'plug_dest'@'santa.claus.ipv4.example.com'; connect con1,"127.0.0.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_ipv4,getnameinfo_fake_ipv4,getaddrinfo_fake_good_ipv4"; uninstall plugin test_plugin_server; ERROR HY000: Plugin 'test_plugin_server' is not loaded connection default; "Dumping performance_schema.host_cache" IP 192.0.2.4 HOST santa.claus.ipv4.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 1 COUNT_AUTH_PLUGIN_ERRORS 1 COUNT_HANDSHAKE_ERRORS 0 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: Plugin 'test_plugin_server' is not loaded connection default; "Dumping performance_schema.host_cache" IP 192.0.2.4 HOST santa.claus.ipv4.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 2 COUNT_AUTH_PLUGIN_ERRORS 2 COUNT_HANDSHAKE_ERRORS 0 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 install plugin test_plugin_server soname 'PLUGIN_AUTH'; ERROR 28000: Access denied for user 'plug'@'santa.claus.ipv4.example.com' (using password: YES) connection default; "Dumping performance_schema.host_cache" IP 192.0.2.4 HOST santa.claus.ipv4.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 2 COUNT_AUTH_PLUGIN_ERRORS 2 COUNT_HANDSHAKE_ERRORS 0 COUNT_PROXY_USER_ERRORS 1 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 28000: Access denied for user 'plug'@'santa.claus.ipv4.example.com' (using password: YES) connection default; "Dumping performance_schema.host_cache" IP 192.0.2.4 HOST santa.claus.ipv4.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 2 COUNT_AUTH_PLUGIN_ERRORS 2 COUNT_HANDSHAKE_ERRORS 0 COUNT_PROXY_USER_ERRORS 2 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 GRANT PROXY ON 'plug_dest'@'santa.claus.ipv4.example.com' TO 'plug'@'santa.claus.ipv4.example.com'; connect con4,"127.0.0.1",plug,plug_dest,test,$MASTER_MYPORT,,,auth_test_plugin; select "Con4 is alive"; Con4 is alive Con4 is alive select user(); user() plug@santa.claus.ipv4.example.com select current_user(); current_user() plug_dest@santa.claus.ipv4.example.com disconnect con4; connection default; "Dumping performance_schema.host_cache" IP 192.0.2.4 HOST santa.claus.ipv4.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 2 COUNT_AUTH_PLUGIN_ERRORS 2 COUNT_HANDSHAKE_ERRORS 0 COUNT_PROXY_USER_ERRORS 2 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 ALL PRIVILEGES ON *.* FROM 'plug_dest'@'santa.claus.ipv4.example.com'; REVOKE PROXY ON 'plug_dest'@'santa.claus.ipv4.example.com' FROM 'plug'@'santa.claus.ipv4.example.com'; DROP USER 'plug'@'santa.claus.ipv4.example.com'; DROP USER 'plug_dest'@'santa.claus.ipv4.example.com'; SET @@GLOBAL.debug_dbug = @saved_dbug; delete from mysql.plugin where name='test_plugin_server';