首页 > 数据库 >MySql Host is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts&#

MySql Host is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts&#

时间:2022-09-01 18:03:11浏览次数:48  
标签:errors many mysqladmin connection unblock because flush hosts

 

原因是:

同一个ip在短时间内产生太多(超过mysql数据库max_connection_errors的最大值)中断的数据库连接而导致的阻塞

 

解决方法:

/usr/bin/mysqladmin flush-hosts -h172.0.0.1 -P3306 -uroot -prootpwd;

 

也可以root登录到mysql

执行:flush hosts;

 

标签:errors,many,mysqladmin,connection,unblock,because,flush,hosts
From: https://www.cnblogs.com/yancool/p/16647384.html

相关文章