create connection SQLException, url: XXXX errorCode 0 ，state 08001

create connection SQLException, url: XXXXXX, errorCode 0, state 08001

关于这个问题 百度了两个多小时 网上众说纷纭但是一个顶用的都没有，首先关注点并不在这里 而是在如下

2022-12-18 01:30:56.022 ERROR 57546 --- [eate-1740826931] com.alibaba.druid.pool.DruidDataSource   : create connection SQLException, url: XXXXXXXXXX, errorCode 0, state 08001java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)        at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:898)        at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:823)        at com.mysql.cj.jdbc.ConnectionImpl.(ConnectionImpl.java:448)        at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241)        at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)        at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1651)        at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1717)        at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2785)Caused by: com.mysql.cj.exceptions.CJException: null,  message from server: "Host 'XXXXXX' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'"

Caused by: com.mysql.cj.exceptions.CJException: null, message from server: “Host ‘XXXXXX’ is blocked because of many connection errors; unblock with ‘mysqladmin flush-hosts’”
主要问题是这行 意思呢大概就是连接错误次数达到上限 所以被mysql把错误上限得到IP拉黑了

找到问题的原因了 接下来就好解决了 解决问题的办法也就在问题的结尾
我们到服务器连接上Mysql 然后执行

flush hosts;

再次启动项目 连接正常搞定

来源地址：https://blog.csdn.net/weixin_42436477/article/details/128359247