com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failureThe last packet s

最新推荐文章于 2025-05-28 08:00:00 发布

原创最新推荐文章于 2025-05-28 08:00:00 发布 · 1.3k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#java #mysql #容器 #docker

java 专栏收录该内容

11 篇文章

订阅专栏

记录一次使用Java连接Docker内的MySQL数据库时遇到的CommunicationsException错误。原本以为配置正常，但出现无法连接的问题。通过排查，发现在数据库URL中需要添加`?useSSL=false`参数，或者配置ssl，最终成功建立连接。修改后的URL为`jdbc:mysql://192.168.6.128:3306/user?useSSL=false`，问题得到解决。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

记录一下今天使用java连接部署在docker容器里的mysql遇到的问题，刚开始以为的跟正常的连接一样，结果报错

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.

弄了有一会，发现还是没用，最后在一篇博客发现原来是配置上要加上

?useSSL=false

需要添加参数useSSL=false，或者配置ssl

即

spring.datasource.url=jdbc:mysql://192.168.6.128:3306/user?useSSL=false

就OK了

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

weixin_46005263

关注关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
分享

复制链接

分享到 QQ

分享到新浪微博

扫一扫
举报

举报

专栏目录

jdbc报错 Caused by: com.mysql.cj.jdbc.exceptions.CommunicationsException: The last packet successfully

yy的博客

09-10

818

• validationQuery=SELECT 1：执行简单的 SQL 查询来测试连接。• testOnBorrow=true：每次获取连接时测试连接是否有效。

若依微服务项目报错解决：com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

猿小白的博客

04-24

2651

在每次重启数据库的时候，登录系统会报错。第一次会出现用户名不存在等情况，后台会报错，前端依旧可以进入，或者等待时间5分钟，期间不做任何操作，重新登录，这个问题就会复现，复现这个问题最快的方法就是重启数据库。

参与评论您还未登录，请先登录后发表或查看评论

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packe

qq_44724114的博客

10-08

850

啥都先别想，去自己的druid；properties文件看一下配置是不是有错误 com.mysql.jdbc.exceptions.jdbc4.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. a

解决com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure, The last packe.

牛肉胡辣汤

11-03

2万+

希望这篇文章能帮助你解决"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."的错误，顺利连接到MySQL服务器。

【一天一坑系列】腾讯TDSQL-mysql数据库偶现高频连接异常，cj.jdbc.exceptions.CommunicationsException: Communication link fail

热门推荐

都是自己踩过的坑的博客

07-29

12万+

bug回顾：想必大家在用MySQL时都会遇到连接超时的问题，如下图所示： Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure The last packet successfully received from the server was 319 milliseconds ago. The last packet sent successfully to the..

com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure异常处理

weixin_43811057的博客

07-02

1403

【代码】com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure异常处理。

全网多种方法解决com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure的问题

念兮为美

03-07

8377

解决com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure错误

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

风学长的博客

03-17

1万+

. ____ _ __ _ _ /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \ ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \ \\/ ___)| |_)| | | | | || (_| | ) ) ) ) ' |____| .__|_| |_|_| |_\__, | / / / / =========|_|==============|___/=/_/_/_/ :: Spr...

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

baidu_38995168的博客

05-12

1249

Error querying database. Cause: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure The last packet successfully received from the server was 14,465,416 milliseconds ago. The last packet sent successfully to the server was 14

mysql 异常com.mysql.jdbc.CommunicationsException

03-03

com.mysql.jdbc.CommunicationsException Communications link failure due to underlying exception:

Cause: com.mysql.cj.jdbc.exceptions.CommunicationsException: The last packet successfully.....

ifever的博客

04-30

3823

Cause: com.mysql.cj.jdbc.exceptions.CommunicationsException: The last packet successfully received from the server was 426,962,099 milliseconds ago. The last packet sent successfully to the server was 426,962,100 milliseconds ago. is longer than the server

You should consider either expiring and/or testing connection validity before use in your applicat

荷塘粤色的专栏

05-24

2265

服务器数据库间断性的会出现数据库连接异常的报错，报错异常为

【问题排查】MySQL 连接异常：com.mysql.cj.jdbc.exceptions.CommunicationsException_ The last packet successfully

甘蓝的专栏

12-27

2766

分析 MySQL 连接超时异常，并提供多种解决方案。

解决：com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failureThe last packe

m0_62202218的博客

04-14

362

springboot连接数据库测试报错

CommunicationsException: Communications link failure

zhangm2020的博客

10-10

1712

SQL自身问题场景曾解决过这种情况，发现是表的数据量过大、SQL未命中索引且查询筛选数据过多，导致SQL超时该情况问题解决：优化SQL，分批次查询系统资源不足场景也遇到过该情况，SQL分析发现，是非常简单的查询，执行仅需要毫秒级别，可以判断去与SQL本身无关。就去查看MySQL监控，发现报错时间段慢查询速率达到了峰值，mysql流量突增

dinky报错：Communications link failure The last packet sent successfully to the server was 0 millisecon

qq_43224174的博客

08-04

942

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.

Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. ...

b1206的博客

05-26

755

为了这个问题，在网上搜了一天，最后发现把mysql的端口号写成了3360 改成3306后，问题不再。为什么忙了一天，沮丧，绝望，抓狂得饭都不吃，就是这么个错误？？以后再也不抓狂了。转载于:https://www.cnblogs.com/ConfuciusPei/archive/2011/05/...

04-22

`com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure` 表示 JDBC 客户端无法与 MySQL 数据库服务器建立有效的通信链接。以下是可能导致该问题的原因及其对应的解决方案： #### 1....