解决:Host xxx.xxx.xxx.xxx is blocked because of many connection errors.

Host “xxx.xxx.xxx.xxx” is blocked because of many connection errors

1.原因:当使用错误的密码连接mysql时，超过设定的次数 IP或主机名就会被mysqld阻塞访问。

①中文

②Mysql官方描述英文  

③解决问题(第三方英文)        

 

 

2.查看关键参数值：

查看 “max_connect_errors”

SHOW VARIABLES LIKE '%max_connect_errors%';

 

3.临时设置 “max_connect_errors”

SET GLOBAL max_connect_errors=10000;

4.永久解决：

修改配置 %MYSQL_HOME%\my.ini       

[mysqld]  

max_connect_errors=1000000