105
Host is blocked because of many connection errors-小鱼的博客-51CTO博客
source link: http://blog.51cto.com/395469372/2066544
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
Host is blocked because of many connection errors
MySQL 出现：Host 'XXXXXX' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
max_connect_errors 参数含义：如果某一客户端尝试连接此MySQL服务器，但是失败（如密码错误等等）X次，则MySQL会无条件强制阻止此客户端连接
解决方法：
1、set global max_connect_errors=1000; --可以动态修改
当这一客户端成功连接一次MySQL服务器后，针对此客户端的max_connect_errors会清零。
2、 mysqladmin flush-hosts 或者 mysql>flush hosts;
©著作权归作者所有：来自51CTO博客作者会说话的鱼的原创作品，如需转载，请注明出处，否则将追究法律责任
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK