mysql出现unblock with 'mysqladmin flush-hosts'

错误信息:

unblock with 'mysqladmin flush-hosts'

这个错误导致我无法远程连接MySQL(使用navicat或sqlyog等mysql客户端工具)

解决办法:
修改max_connect_errors的值

(1)进入Mysql数据库查看max_connect_errors:
> show variables like '%max_connect_errors%';
(2)修改max_connect_errors的值:
> set global max_connect_errors = 100;
(3)查看是否修改成功
> show variables like '%max_connect_errors%';

参考资料:
mysql出现unblock with ‘mysqladmin flush-hosts’

posted @ 2020-09-30 20:48  挑战者V  阅读(967)  评论(0编辑  收藏  举报