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

我来说两句

显示全部

:loveliness: :handshake :victory: :funk: :time: :kiss: :call: :hug: :lol :'( :Q :L ;P :$ :P :o :@ :D :( :)

Open Toolbar