当jdbc.properties文件的所有配置都没问题,数据库的my.ini配置文件也没问题时,且重启数据库问题也依然存在,此时还有一种可能原因导致数据库无法连接。
相关的报错如下:
idea方面:
[ERROR] create connection SQLException, url: jdbc:mysql://localhost:3306/kks?useSSL=false&serverTimezone=UTC&characterEncoding=utf-8&allowPublicKeyRetrieval=true, errorCode 1129, state HY000
java.sql.SQLException: null, message from server: "Host '222.184.15.251' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'"
at com.mysql.jdbc.SQLError.createSQLException (SQLError.java:965)
at com.mysql.jdbc.SQLError.createSQLException (SQLError.java:898)
at com.mysql.jdbc.SQLError.createSQLException (SQLError.java:887)
at com.mysql.jdbc.MysqlIO.doHandshake (MysqlIO.java:1038)
at com.mysql.jdbc.ConnectionImpl.coreConnect (ConnectionImpl.java:2199)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly (ConnectionImpl.java:2230)
at com.mysql.jdbc.ConnectionImpl.createNewIO (ConnectionImpl.java:2025)
at com.mysql.jdbc.ConnectionImpl.<init> (ConnectionImpl.java:778)
at com.mysql.jdbc.JDBC4Connection.<init> (JDBC4Connection.java:47)
at sun.reflect.GeneratedConstructorAccessor36.newInstance (Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance (DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance (Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance (Util.java:425)
at com.mysql.jdbc.ConnectionImpl.getInstance (ConnectionImpl.java:386)
at com.mysql.jdbc.NonRegisteringDriver.connect (NonRegisteringDriver.java:330)
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection (DruidAbstractDataSource.java:1596)
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection (DruidAbstractDataSource.java:1662)
at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run (DruidDataSource.java:2601)
用数据库工具测试连通性的报错:
[HY000][1129] null, message from server: "Host 'localhost' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'".
以下是解决办法:
输入以下指令,输入密码即可
mysqladmin -u <要连接的数据库用户名> -p flush-hosts
原因分析:
MySQL 服务器阻止了你的 IP 地址的连接,原因是该 IP 地址发生了很多连接错误。(估计是之前的错误配置,循环发送请求,导致不停的向数据库发送错误连接请求),然后MySQL就把你的IP给阻止了,该命令用来解除对该 IP 地址的阻止。