解決:Host xxx.xxx.xxx.xxx is blocked because of many connection errors.，blockederrors

解決:Host xxx.xxx.xxx.xxx is blocked because of many connection errors.，blockederrors

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