MySQL Host ' XXXXXX ' is blocked because of many connection errors
ERROR 1129 (00000): Host ' XXXXXX ' is blocked because of many connection errors; Unblock with ' mysqladmin flush-hosts '
I checked the information.
This indicates that MYSQLD has been given a large number (max_connect_errors) of host ' hostname ' in the Midway interrupted connection request. After max_connect_errors a failed request, MYSQLD identified an error (like a hacker attack) and blocked further connections to the site until someone executed the command mysqladmin flush-hosts.
By default, mysqld blocks a host after 10 connection errors. You can easily adjust it by starting the server like this: set global max_connect_errors=1000;
Note that for a given host, if you get this error message, you should first check the TCP/IP connection for that host for any problems. If your TCP/IP connection is not running, increasing the value of the max_connect_errors variable will not help you!
Cases:
192.168. 50.1 -uroot
Attached: English
ERROR 1129 (00000): Host "is blocked because of many connection errors. Unblock with ' mysqladmin flush-hosts '
in connection errors. You can adjust the value by starting the serverlike this > mysqld_safe–max_connect_errors=10000 &hos T
MySQL Host ' XXXXXX ' is blocked because of many connection errors