| Server IP : 45.40.142.9 / Your IP : 216.73.216.250 Web Server : Apache System : Linux s45-40-142-9.secureserver.net 2.6.32-754.35.1.el6.x86_64 #1 SMP Sat Nov 7 12:42:14 UTC 2020 x86_64 User : bayspec ( 506) PHP Version : 5.6.40 Disable Function : NONE MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /usr/share/mysql-test/suite/perfschema/r/ |
Upload File : |
flush status; flush hosts; flush user_resources; flush privileges; select @@global.debug; @@global.debug select @@global.max_connect_errors; @@global.max_connect_errors 100 select @@global.max_user_connections; @@global.max_user_connections 0 select @@global.max_connections; @@global.max_connections 151 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 'user_without'@'santa.claus.ipv4.example.com'; create user 'user_with'@'santa.claus.ipv4.example.com' identified by 'good_password'; grant select on test.* to 'user_without'@'santa.claus.ipv4.example.com'; grant select on test.* to 'user_with'@'santa.claus.ipv4.example.com'; select "Con1 is alive"; Con1 is alive Con1 is alive select current_user(); current_user() root@localhost set global debug= "+d,vio_peer_addr_fake_ipv4,getnameinfo_fake_ipv4,getaddrinfo_fake_good_ipv4"; ERROR 28000: Access denied for user 'user_without'@'santa.claus.ipv4.example.com' (using password: YES) "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 0 COUNT_AUTH_PLUGIN_ERRORS 0 COUNT_HANDSHAKE_ERRORS 0 COUNT_PROXY_USER_ERRORS 0 COUNT_PROXY_USER_ACL_ERRORS 0 COUNT_AUTHENTICATION_ERRORS 1 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 'user_without'@'santa.claus.ipv4.example.com' (using password: YES) "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 0 COUNT_AUTH_PLUGIN_ERRORS 0 COUNT_HANDSHAKE_ERRORS 0 COUNT_PROXY_USER_ERRORS 0 COUNT_PROXY_USER_ACL_ERRORS 0 COUNT_AUTHENTICATION_ERRORS 2 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 'user_with'@'santa.claus.ipv4.example.com' (using password: NO) "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 0 COUNT_AUTH_PLUGIN_ERRORS 0 COUNT_HANDSHAKE_ERRORS 0 COUNT_PROXY_USER_ERRORS 0 COUNT_PROXY_USER_ACL_ERRORS 0 COUNT_AUTHENTICATION_ERRORS 3 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 'user_with'@'santa.claus.ipv4.example.com' (using password: NO) "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 0 COUNT_AUTH_PLUGIN_ERRORS 0 COUNT_HANDSHAKE_ERRORS 0 COUNT_PROXY_USER_ERRORS 0 COUNT_PROXY_USER_ACL_ERRORS 0 COUNT_AUTHENTICATION_ERRORS 4 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 'user_with'@'santa.claus.ipv4.example.com' (using password: YES) "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 0 COUNT_AUTH_PLUGIN_ERRORS 0 COUNT_HANDSHAKE_ERRORS 0 COUNT_PROXY_USER_ERRORS 0 COUNT_PROXY_USER_ACL_ERRORS 0 COUNT_AUTHENTICATION_ERRORS 5 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 'user_with'@'santa.claus.ipv4.example.com' (using password: YES) "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 0 COUNT_AUTH_PLUGIN_ERRORS 0 COUNT_HANDSHAKE_ERRORS 0 COUNT_PROXY_USER_ERRORS 0 COUNT_PROXY_USER_ACL_ERRORS 0 COUNT_AUTHENTICATION_ERRORS 6 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 drop user 'user_with'@'santa.claus.ipv4.example.com'; drop user 'user_without'@'santa.claus.ipv4.example.com'; set global debug= default;