Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure

ゝ一纸荒年。 2023-07-10 14:09 8阅读 0赞

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.  
    at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174) ~\[mysql-connector-java-8.0.16.jar:8.0.16\]  
    at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64) ~\[mysql-connector-java-8.0.16.jar:8.0.16\]  
    at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:835) ~\[mysql-connector-java-8.0.16.jar:8.0.16\]  
    at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:455) ~\[mysql-connector-java-8.0.16.jar:8.0.16\]  
    at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240) ~\[mysql-connector-java-8.0.16.jar:8.0.16\]  
    at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199) ~\[mysql-connector-java-8.0.16.jar:8.0.16\]  
    at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1513) ~\[druid-1.1.8.jar:1.1.8\]  
    at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1578) ~\[druid-1.1.8.jar:1.1.8\]  
    at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2451) ~\[druid-1.1.8.jar:1.1.8\]  
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure

我连接的是阿里云数据库。项目连接不上数据库，使用图形化工具也连接不上，最后查找原因是连接的内网地址导致连接不上。

项目连接的url填成了内网地址，应该填外网地址。

白名单的设置不能设置为本机的ip地址，而应该是外网ip：百度搜索“ip”出现的ip地址