java.sql.SQLException: null, message from server: "Host '192.168.16.181' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'"

 java.sql.SQLException: null,  message from server: "Host '192.168.16.181' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'"

出现以上报错的原因:

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

解决办法:

 

posted @ 2019-09-04 14:14  akrgjkls  阅读(3409)  评论(0编辑  收藏  举报