连接mysql报错 errorCode 1129, state HY000, Host ‘xxx‘ is blocked because of many connection errors
连接mysql报错 create connection SQLException, url: xxx errorCode 1129, state HY000java.sql.SQLException: null,message from server: "Host '192.168.56.1' is blocked because of many connection errors; unbloc
·
springcloud项目启动连接mysql过程中报错.
报错关键信息如下:
java.sql.SQLException: null, message from server: "Host '192.168.56.1' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'"
错误原因:
mysql设定了单个客户端最大连接失败次数,超过后便无法再连接成功.
可命令行查看: 最大失败数为100.
解决方法:
1.进入mysql控制台,修改max_connect_errors:
set global max_connect_errors=99999;
若想永久生效,去my.conf文件手动添加或修改该行命令.
但方法1不推荐,修改该数值越大,被攻击时安全性越低.
2.进入mysql控制台,把缓存计数清除掉,重启项目即可:
flush hosts;
更多推荐
已为社区贡献5条内容
所有评论(0)