MySQL : Host host-name is Blocked Because of Many Connection Errors
August 12 2014
The following error show on nagios mysql monitoring status,
The MySQL max_connect_errors variable to determines number of succesive interrupted connection requests are allowed after over crossing max_connect_errors that connections are not successful.
To execute the below command flush all cached hosts,
# mysqladmin flush-hosts
By default, it will blocks a host after 10 connection errors.
mysql > SET GLOBAL max_connect_errors=10000;
if you having any network connection problem, no need to increase the max_connect_error.