MySQL超过最大连接数量

MySQL 评论

报错

1
SQLSTATE[HY000] [1129] Host '172.20.0.1' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts' (SQL: select * from `user` where `openid` = oQxMh5b_yYB6YjK74C5l73T5vGZ0 limit 1)

环境

docker mysql8
几乎处于无人使用的状态

解决

1
flush hosts;

为什么会发生这样的问题呢？