com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

最新推荐文章于 2024-06-21 15:21:23 发布

chr35

最新推荐文章于 2024-06-21 15:21:23 发布

阅读量283

点赞数 3

文章标签： mysql 数据库 java

本文链接：https://blog.csdn.net/chr35/article/details/137089306

版权

文章描述了在使用Druid数据源连接CentOS8系统上MySQL5.7.44时遇到的CommunicationsException错误，指出不同mysql-connector-java版本的影响，并提到了一个可能的解决方法是升级到特定版本(8.0.27)。

摘要由CSDN通过智能技术生成

背景

druid数据源连接centOs8下 mysql 5.7.44报

Exception in thread "main" com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

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)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:835)
	at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:455)
	at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
	at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:207)
	at java.sql.DriverManager.getConnection(DriverManager.java:664)
	at java.sql.DriverManager.getConnection(DriverManager.java:247)
	at com.ruoyi.GetScore.main(GetScore.java:18)
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure

必现，修改druid和mysql参数无效，换项目能正常连接，对比发现依赖版本不同

可以的版本

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.27</version>
        </dependency>

失败的版本

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.13</version>
        </dependency>

记录，希望对你用，有用给个赞吧