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

MySQL端口配置错误排查

最新推荐文章于 2025-09-12 16:05:03 发布

转载最新推荐文章于 2025-09-12 16:05:03 发布 · 773 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/ConfuciusPei/archive/2011/05/26/5118433.html

文章标签：

#数据库

本文记录了一次因将MySQL默认端口3306误写为3360而导致的问题排查经历。作者在经历一天的沮丧、绝望和抓狂后，最终发现只需将端口改回正确的3306即可解决问题。

为了这个问题，在网上搜了一天，最后发现

把mysql的端口号写成了3360

改成3306后，问题不再。

为什么忙了一天，沮丧，绝望，抓狂得饭都不吃，就是这么个错误？？

以后再也不抓狂了。

转载于:https://www.cnblogs.com/ConfuciusPei/archive/2011/05/26/5118433.html

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

b1206

关注关注

0
点赞
踩
0

收藏

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

复制链接

分享到 QQ

分享到新浪微博

扫一扫
举报

举报

【Mysql】Communications link failure，The last packet sent successfully to the server was 0 millisecond

A-Itfuture的博客

12-03

2万+

解决错误【Mysql】Communications link failure，The last packet sent successfully to the server was 0 millisecond

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

qq_43224174的博客

08-04

1015

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.

weixin_67935119的博客

09-12

413

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.

【java报错解决】Communications link failure The last packet sent successfully to the server was 0 millise

qq_53328894的博客

09-15

618

解决java服务长时间未连接mysql，druid连接池抛出的异常问题

Communications link failure The last packet sent successfully to the server

AinUser的博客

09-27

1万+

情境：我出现这个错误是因为，我下载了一个开源的项目，使用docker-compose程序，其中mysql服务并没哟对外映射端口解决：修改配置文件，使mysql对外映射端口你们的情况可能是mysql的服务并没有启动，如果是windows请自行去服务里面查看 ...

Mac下 Communications link failure，The last packet sent successfully to the server was 0 milliseconds

shao_feng_ocean的博客

05-22

1216

Mac必须允许用户远程访问数据库才能链接mysql 1、打开终端，进入MySQL之后 2、输入以下语句，进入mysql库： use mysql; 3、更新域属性，'%'表示允许外部访问： update user set host='%' where user ='root'; 4、执行以上语句之后再执行(刷新配置)： FLUSH PRIVILEGES; 5、再执行授权语句： GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'WITH GRANT OPT.

IDEA连接Mysql数据库报错：“The last packet sent successfully to the server was 0 milliseconds ago.”

weixin_59744818的博客

11-26

1万+

今天IDEA使用druid连接Mysql数据库报错，MySQL版本5.7.34，druid-spring-boot-starter版本1.1.13。更新druid版本到最新1.2.6也没用。 “The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.” “No appropriate protocol (p

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 a

03-08

当遇到 `Communications link failure` 错误，并且最后一个数据包发送时间为0毫秒，驱动未收到任何来自服务器的数据包时，这通常表明客户端与MySQL服务器之间的网络连接存在问题。 #### 1. 检查网络连接状态确认...

[08S01] 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. The driver has not received any packets from the server.

10-28

错误代码 [08S01] 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.” 表明客户端与...

gbase Communications link failure The last packet successfully received from the server was 426 milliseconds ago. The last packet sent successfully to the server was 423 milliseconds ago.

最新发布

11-11

“Communications link failure” 错误通常表示客户端与数据库服务器之间的连接出现问题。以下是一些可能的解决办法： ### 网络层面 - **检查网络连接**：确保客户端和 GBase 数据库服务器之间的网络连接正常，可...

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.

07-31

> The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. 说明客户端在尝试与数据库建立连接时，未能从服务器接收到任何响应数据包...

pycharm连接mysql [08S01] Communications link failureThe last packet sent successfully to the server...

Dxh0112_的博客

10-19

567

我的报错就是上面所说的，我看有其他人发的将Advanced中的userSSL改为false，但是还是连接不上，然后我又将下图所圈住的点了对勾，点击连接就可以了。

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

qq_50065658的博客

02-24

1396

今天在学习springboot之Mybatis逆向工程的时候，在加入所有的依赖和配置好文件之后，在Maven中进行，mybatis-generate操作时，出现了此类报错。于是，在网上还是寻求报错解决方法，找了很多种，大部分都是修改配置文件，说什么连接时间问题，都一一试过，没有作用。最后看到一条评论，说是mysql 依赖版本太高，当时我的是8.0.13，抱着试一试的状态，改成了5.0.9 结果成功Build，至此问题解决。大家如果有此问题，可以先试着降低mysql依赖的版本，如果有用的话，评论点个赞，谢

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

qq_47892703的博客

07-03

3241

识别和获取 MySQL 数据库的地址而导致连接失败（该方式适用于 Docker 而不适用于 Windows）。虽然并不是什么“高深”的问题，半天没找到“症结”还是挺烦人😂。出现与 MySQL 连接失败的原因有多种，通过尝试网上其他方法并未解决问题。通过排查，最终发现是无法通过。无法与 MySQL 通信并建立连接（Docker 中该方式可正常运行），修改为。运行环境为 Windows，所以通过服务名称。将 MySQL 配置。

[08S01] Communications link failure The last packet sent successfully to the server was 0 milliseco

大白鱼的博客

07-17

1056

解决问题：[08S01] 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. No appropriate protocol (protocol is disabled or cipher suites are inappropriate). Py

[08S01] Communications link failure The last packet sent successfully to the server was 0 milliseco

热门推荐

Zhangjiangyuan的博客

12-11

3万+

问题缘由折腾半天的mysql故障问题，本来下午准备使用DG练习一下sql,但是解决问题首先排除是驱动的鼓掌，使用终端命令进入试试报错，可以进一步得出结论，是windows中mysql服务可能没有启动，点击进入win服务注册表：来回找了两遍，发现根本不存在mysql的服务，可能时候腾讯电脑管家，为了提升开机速度优化，把一些系统默认的启动项关掉输入命令启动mysql的后台任务：排查发现需要使用管理员权限, 管理员环境下启动成功，查看本地的服务目录：服务已经存在，双击开启服务，但是出现了

连接 Linux 阿里云报错-[08S01] Communications link failure The last packet sent successfully to the serve

一颗小白羊

06-30

8482

[08S01] 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. java.net.ConnectException: Operation timed out (Connection timed out). 1、登录阿里云控制台，选择配置规

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

qq_43786558的博客

03-31

1万+

今天打开IDEA时MySQL出了错误 Communications link failure 通讯链路故障我运行cmd(管理员身份)net start mysql 结果然后我手动启动MySQL，显示我的解决方法：第一步：删除MySQL里的data文件夹第二步：运行cmd(管理员身份)，进入E:\mysql8\bin目录下，输入mysqld --initialize(无返回值)初始化data文件，然后输入mysqld --install 它会显示是否安装成功第三步：继续输

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

10-08

这个错误通常发生在与数据库服务器的连接上，可能是由于网络问题或服务器故障导致的通信链路断开。可以尝试以下解决方案： 1. 检查网络连接：确保你的网络连接正常。尝试连接其他网站或服务，看是否有类似的问题。 2. 检查数据库服务器：确认数据库服务器是否正常运行。可以尝试重启数据库服务器并重新连接。 3. 检查数据库连接配置：检查数据库连接的URL、用户名和密码是否正确。确保没有任何拼写错误或错误的配置。 4. 增加连接超时时间：如果问题仍然存在，可以尝试增加连接超时时间。在连接数据库时设置较长的超时时间，以便在网络不稳定或延迟较高的情况下等待更长时间。 5. 联系数据库管理员：如果以上解决方案都无效，建议联系数据库管理员或运维团队寻求进一步的帮助。