Mysql - Error host name is blocked too many connection, Host host_name is blocked

Error host name is blocked too many connection

Error:

Host 'host_name' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'


In mysql the number of connection is determined by mysql system variable 'max_connect_errors'

Mysql will assume that some thing is wrong with the host and it will block the host. To unblock the host you have to execute the below command

 # mysqladmin flush-hosts 

By default, mysqld blocks a host after 10 connection errors. You can adjust the value by starting the server like this:

 # mysqld_safe --max_connect_errors=10000 &

The FLUSH statement clears or reloads various internal caches used by MySQL. One variant acquires a lock. To execute FLUSH, you must have the RELOAD privilege.

By default, FLUSH statements are written to the binary log so that they will be replicated to replication slaves. Logging can be suppressed with the optional NO_WRITE_TO_BINLOG keyword or its alias LOCAL.

Before executing the FLUSH command you should be aware that FLUSH LOGS, FLUSH MASTER, FLUSH SLAVE, and FLUSH TABLES WITH READ LOCK are not written to the binary log in any case because they would cause problems if replicated to a slave.

To see the current variables and values used by the mysql server use SHOW VARIABLES statement. This will display all the values of mysql variables.

 mysql> SHOW VARIABLES;

You can use the LIKE clause to get the value of a particular variable

 mysql> SHOW VARIABLES LIKE '%size%';

 mysql> SHOW SESSION VARIABLES LIKE 'max_join_size';

 mysql> SHOW GLOBAL VARIABLES LIKE '%size%';

All the above steps which I followed and executed to fix the error host_name is blocked because of too many connections, hope it will be very helpful for you too.

The topic on Mysql - Error host name is blocked too many connection is posted by - Math

Hope you have enjoyed, Mysql - Error host name is blocked too many connectionThanks for your time