解决ERROR 1129 (HY000): Host ‘xxx‘ is blocked because of many

报错:

ERROR 1129 (HY000): Host '27.227.134.197' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

解决:

mysql> flush hosts;

如果以上报如下错，则使用下面步骤:

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-hosts' at line 1
mysql> show variables like "max_connection_errors";

1.首先使用 root 登录 mysql -u root -p 或者
mysql -uroot -h39.97.49.66 -p

2.提高允许的max_connection_errors数量：

① 进入Mysql数据库查看

max_connection_errors： show variables like "max_connection_errors";

② 修改max_connection_errors的数量为1000：

set global max_connect_errors = 1000;

③ 修改 max_connections 的数量为1000 ：

set global max_connections = 1000;

3.最后使用 mysql> flush-hosts; 命令清理一下hosts文件；