文章内容
2020/8/22 8:56:04,作 者: 黄兵
is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
今天查看服务器日志，出现如下错误：
sqlalchemy.exc.OperationalError: (MySQLdb._exceptions.OperationalError) (1129, "Host '123.123.123.123' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'")
racknerd-f314ba uwsgi[1120244]: (Background on this error at: http://sqlalche.me/e/e3q8)
出现错误的原因：
MySQL阻止连接时出错的客户端，以保护MySQL免受格式错误的客户端的侵害。
您可能会在数据目录中检查MySQL错误日志。（通常是hostname.err）
解决方案：
FLUSH HOSTS 可以帮助您立即消除被阻止的主机。
mysql> FLUSH HOSTS;
参考资料：
1、Why MySQL connection is blocked of many connection errors?
黄兵个人博客原创。
转载请注明出处：黄兵个人博客 - is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
Cannot add or update a child row: a foreign key constraint fails
redis-cli (error) NOAUTH Authentication required
redis-cli (error) NOAUTH Authentication required
评论列表