mysql is blocked because of many connection errors

  |   0 评论   |   1,503 浏览

错误信息:

Host 'xxx.xxx.xxx.xxx' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'Connection closed by foreign host

原因:是同一IP的connection errors超出默认的最大值了。

方法一:通过命令行进行mysql控制台
输入 flush hosts

方法二:修改max_connect_errors连接数

mysql> set global max_connect_errors = 500;
Query OK, 0 rows affected (0.00 sec)

mysql> show variables like '%max_connect_errors%';
+--------------------+-------+
| Variable_name      | Value |
+--------------------+-------+
| max_connect_errors | 500   |
+--------------------+-------+
1 row in set (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)


最后重启mysql服务 service mysql restart

评论

发表评论