MySQL connection error: MySQL Host is blocked because of many connection errors

Environment: linux,mysql5.5.31 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_connect_errors% ';

② Modify the number of max_connection_errors to 1000:set global max_connect_errors = 1000;

③ See if the change was successful: show variables like '%max_connect_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 connection error: MySQL Host is blocked because of many connection errors