"Host 'X.X.X.X' is blocked because of many connection errors; unblock with 'mysqladmin flush-ho

Mysql 连接报错: "Host 'X.X.X.X' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'"

原因：同一个ip在短时间内产生太多（超过mysql数据库max_connection_errors的最大值）中断的数据库连接而导致的阻塞 （短时间内链接错误次数过多）

解决办法：用其他电脑登录数据库 执行 flush hosts 命令

总结：max_connection_errors可以设置 如果有需要可以将该值调大
 

参考: https://www.linuxidc.com/Linux/2017-03/141640.htm

参考: https://blog.youkuaiyun.com/shuleibaihe/article/details/80941837