mysql error number 1129 solution

SQLyog connects to mysql error number 1129:

mysql error 1129: Host 'bio.chip.org' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'.

Solution:

cmd command line:

mysqladmin flush-host -h 127.0.0.1 -u root -p123456

solve.

Extended Learning

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

reason:

The same IP generates too many interrupted database connections (exceeding the maximum value of max_connection_errors of MySQL database) in a short period of time, causing blocking;

Solution:

1. Increase the number of max_connection_errors allowed (only treats the symptoms but not the root cause):

① Enter the Mysql database to view max_connection_errors: show variables like '%max_connection_errors%';

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

③ Check whether the modification is successful: show variables like '%max_connection_errors%';

2. Use the mysqladmin flush-hosts command to clean up the hosts file (if you don't know which directory mysqladmin is in, you can use the command: whereis mysqladmin to find it);

① Use the command to modify in the found directory: /usr/bin/mysqladmin flush-hosts -h192.168.1.1 -P3308 -uroot -prootpwd;

Remark:

The port number, user name, and password can be added and modified as needed;

If you have configured a master/slave database, you need to modify both the master and slave databases (I suffered this loss. It took me half a day to finish a few simple commands).

The second step can also be performed in the database, the command is as follows: flush hosts;

Most of the Baidu results are like this, but it still doesn't work for my database connection. After multiple verifications, I found that I needed to add the host address, that is, execute: mysqladmin flush-hosts -h 127.0.0.1 -uroot -p command

The above are the detailed methods and steps for this solution. Thank you for your support of 123WORDPRESS.COM.