Environment:linux,mysql5.5.21
Error: Host is blocked because of many connection errors; Unblock with ' mysqladmin flush-hosts '
Reason:
Congestion caused by the same IP in a short period of time resulting in too many (exceeding the maximum value of MySQL database max_connection_errors) interrupted database connections;
Workaround:
1, increase the allowable number of max_connection_errors (Temporary Cure):
① into MySQL database view max_connection_errors: show variables like '%max_connection_errors% ';
② Modify the number of Max_connection_errors: set global max_connect_errors = +;
③ See if the change was successful:show variables like '%max_connection_errors% ';
2, use mysqladmin flush-hosts command to clean up the Hosts file (do not know mysqladmin in which directory can use command lookup:whereis mysqladmin);
① in the found directory using the command to modify:/usr/bin/mysqladmin flush-hosts-h192.168.1.1 -p3308 -uroot-prootpwd;
Note:
Where the port number, user name, password can be added and modified as needed;
Configuration has master/slave master and slave database to the main library and from the library are modified again (I ate this loss obviously very easy several command results toss the most days);
The second step can also be done in the database, the command is as follows:flush hosts;
MySql Host is blocked because of many connection errors; Unblock with ' mysqladmin flush-hosts ' workaround