MySql Host is blocked because of many connection errors; Unblock with ' mysqladmin flush-hosts ' workaround

MySql Host is blocked because of many connection errors; Unblock with ' mysqladmin flush-hosts ' workaround

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