MySQL 无法连接 [MySql Host is blocked because of many connection errors]

MySQL 报错 Host is blocked because of many connection errors; unblock with ‘mysqladmin flush-hosts’

原因：同一个 ip 在短时间内产生太多中断的数据库连接而导致的阻塞。

解决方案：

  1. set global max_connect_errors = 5000 或者更大

  2. 或者修改my.cnf max_connect_errors = 5000 或者更大

临时修复方案：

flush hosts

#MySQL