If the following error occurs: Host 'xxxx' isblockedbecauseofmanyconnectionerrors, you only need to modify setglobalmax_connect_errors1000 in my. ini; the following 1000 is the connection size.
If the following error occurs: Host 'xxxxxx' is blocked because of unknown connection errors, you only need to modify set global max_connect_errors = 1000 in my. ini; the following 1000 is the proper connection size.
ERROR 1129 (00000): Host 'xxxxxx' is blocked because of your connection errors; unblock with 'mysqladmin flush-hosts'
This indicates that mysqld has obtained a large number of connection requests (max_connect_errors) that are interrupted in the middle of the host 'hostname. After the max_connect_errors failed request, mysqld considers that an error has occurred and stops the site from connecting further until someone executes the command mysqladmin flush-hosts.
By default, mysqld blocks a host after 10 connection errors. You can easily adjust it:
Set global max_connect_errors = 1000;
Note: If you receive this error message for a given host, you should first check whether the TCP/IP connection of the host is correct. If your TCP/IP connection is not running, adding the max_connect_errors variable value will not help!
Finally, restart mysql or/usr/local/mysql/bin/mysqladmin flush-host-h 192.168.50.1-uroot to solve the problem.