错误提示:
ERROR 2017-04-17 15:19:04,161 com.alibaba.druid.pool.DruidDataSource: {dataSource-77} init error
java.sql.SQLException: null, message from server: "Host '192.168.10.75' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'"
大概翻译:
host本机ip被锁因为多次连接错误,解锁方法执行mysqladmin flush-hosts'
原因:
mysql请求连接mysql先请求host文件,当ip错误次数达到最大错误数时,超过mysql数据库max_connection_errors的最大值 发生阻塞,返回错误码。
从而连接不到数据库。
解决方法:修改host文件max_connection_errors值,改大一些
相关文章
- mysql host is blocked because of many connection errors; unb
- mysql host is blocked because of many connection errors; unb
- MySql Host is blocked because of many connection errors;
- mysql host is blocked because of many connection errors; unb
- mysql host is blocked because of many connection errors; unb
- mysql 连接报错is blocked because of many connection errors; 解决方法