How to troubleshoot MySQL host host_name is blocked

By default, Mysqld shields the host after a 10-time connection error. You can adjust the value by starting the server in the following ways

If you encounter the following error, MYSQLD has received many connection requests from the host "Host_name", but the host is interrupted in the middle.

Host ' Host_name ' is blocked due to a lot of connection errors.

You can use ' mysqladmin flush-hosts ' to remove the mask.

The number of allowable interrupt connection requests is determined by the value of the max_connect_errors system variable. When the connection request specified by Max_connect_errors is exceeded, Mysqld considers an error (for example, someone is attempting to insert) and shields the host from further connection requests until the Mysqladmin flush-hosts command is executed, or the flush Hosts statement.

By default, Mysqld shields the host after a 10-time connection error. You can adjust the value by starting the server in the following ways:

shell> mysqld_safe --max_connect_errors=10000 &

If you encounter this error on a given host, you should first verify that the TCP/IP connection for that host is correct. If there is a network problem, increasing the value of the max_connect_errors variable will not do any good.