MySQL :Host 'XXXXXX' is blocked because of many connection errors;

上一篇 / 下一篇  2019-02-21 16:25:36 / 个人分类:mysql


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

解决方法:
1、set global max_connect_errors=1000; --可以动态修改

当这一客户端成功连接一次MySQL服务器后,针对此客户端的max_connect_errors会清零。

2、 mysqladmin flush-hosts 或者 mysql>flush hosts;


TAG:

 

评分:0

我来说两句

Open Toolbar