How to solve the MySQL problem -- Host host_name is blocked

By default, mysqld shields the host after 10 connection errors. You can adjust the value by starting the server as follows:

If the following error occurs, mysqld has received many connection requests from the host "host_name", but the host is interrupted.

Host host_name is blocked due to many connection errors.

You can use mysqladmin flush-hosts to unblock it.

The number of allowed connection interruption requests is determined by the value of the max_connect_errors system variable. When the number of connection requests exceeds the value specified by max_connect_errors, mysqld considers an error (for example, someone is attempting to insert) and shields further connection requests from the host, until the mysqladmin flush-hosts command is executed or the flush hosts statement is issued.

By default, mysqld shields the host after 10 connection errors. You can adjust the value by starting the server as follows:

Shell> mysqld_safe -- max_connect_errors = 10000 &

If this error occurs on the specified host, check whether the TCP/IP connection of the host is correct. Adding the value of the max_connect_errors variable is not advantageous if there is a network problem.