The driver has not received any packets from the server，java.net.ConnectException: Connection refuse

已于 2022-08-12 08:15:18 修改
阅读量2.2w 收藏 8
点赞数 2
文章标签： 数据库 intellij-idea mysql
于 2022-08-12 08:04:15 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_43290655/article/details/126296389
版权

文章目录

问题一、idea中db navigator插件 The driver has not received any packets from the server或者是database对话框java.net.ConnectException: Connection refused: connect.

DB browser对话框中错误提示：Cannot connect to “Connection”.
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.

database对话框java.net.ConnectException: Connection refused: connect.
在这里插入图片描述
在这里插入图片描述

原因：The driver has not received any packets from the server.
意思是驱动程序没有收到来自服务器的任何数据包。也就是没有开启mysql数据库。java.net.ConnectException: Connection refused: connect.这个也是数据库连接有问题
解决方法：用datagrip工具也可以如此解决
在这里插入图片描述
在这里插入图片描述

问题二、如果怀疑是驱动问题就去官网下载mysql连接包

如下图，选择下载好的驱动jar包即可连接成功
具体参考https://developer.aliyun.com/article/934533
在这里插入图片描述

问题三、database对话框：Server returns invalid timezone. Go to ‘Advanced’ tab and set ‘serverTimezone’ property manually.

在这里插入图片描述
原因：Go to ‘Advanced’ tab and set ‘serverTimezone’ property manually.意思是进入“Advanced”选项卡，手动设置“serverTimezone”属性。
解决办法：
1、时区问题可以直接在URL后面添加?serverTimezone=Asia/Shanghai
2、Advanced选项卡，手动设置“serverTimezone”属性为Asia/Shanghai
在这里插入图片描述

JTang_java
关注
  • 2
    点赞
  • 踩
  • 8
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
MySQL----JDBC无法连接数据库，报The driver has not received any packets from the server的解决办法
redrose2100的博客
04-14 7481
3、但是手动可以连接数据库，本地调试JAVA代码也是可以连接数据库，使用k8s部署后就会出现此问题。（2）然后在pom.xml文件中增加配置如下内容。（1）在JDBC的连接的URL后面加上如下内容。2、过一会JDBC连接超时，报如下错误。1、JDBC连接数据库时卡在如下位置。（3）重新部署后，解决。
AnalyzeIPv4_WinPcap.cpp.rar_The Handle_pcap_pcap_loop
09-19
该程序同样通过WinPcap提供的函数，获取网络适配器，利用函数pcap_loop（pcap_t* p,int cnt,pcap_handle dispatch_handle,u_char* user）捕获数据包。The program provided the same function through the WinPcap, access network adapter, using function pcap_loop (pcap_t* p, int cnt, pcap_handle dispatch_handle, u_char* user) to capture packets.
生产环境应用无法创建数据库连接问题解决 The driver has not received any packets from the server
zhang_yyii1的博客
09-19 7585
生产环境应用无法创建数据库连接问题解决 The driver has not received any packets from the server 背景： 业务小伙伴报告系统页面打不开进不去，无法正常操作； 遂查看日志 一、问题 以下是log com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications li...
The driver has not received any packets from the server.
最新发布
m0_64307175的博客
03-13 538
在启动项目时，项目没有问题，用postman测试登录模块时出现：The driver has not received any packets from the server.解决：因为电脑关机，mysql服务关闭了，只需要开启mysql服务，电脑有两个sql端口，使用3306端口时可以利用Wampserver开启服务。
连接mysql时报错：The driver has not received any packets from the server.
sanqianqiqi的博客
08-29 4400
连接mysql报错：The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
连接服务器数据库出现问题：The driver has not received any packets from the server.（暴力解决，会导致数据丢失，因此需要有备份，慎用！！！）
m0_53917001的博客
10-24 1万+
在云服务器上使用mysql数据库，发现突然连不上了，报错： W/System.err: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure W/System.err: W/System.err: The last packet sent successfully to the server was 0 milliseconds ago
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received
扬帆天涯
01-12 9559
最近在公司使用jdbc连接数据库时发现了一个奇怪的问题，我把问题的详细错误信息都粘贴下来了。 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 ser
Java启动异常：The driver has not received any packets from the server
weixin_42254034的博客
07-10 4万+
Java启动异常：The driver has not received any packets from the server 原因：驱动程序没有收到来自服务器的任何数据包，说人话就是数据库服务停止了。 解决： 重启mysql：service mysqld start 或者 service mysqld restart ...
今天遇到一个错误The driver has not received any packets from the server.
ShiningSilver的博客
09-09 7万+
今天遇到一个错误The driver has not received any packets from the server. 花了我接近一天的时间 直到最后才发现是端口号的问题Communications link failure
The driver has not received any packets from the server
qq_38864315的博客
03-25 3287
idea启动本地项目提示报错“The driver has not received any packets from the server”，可能是数据库Mysql服务被停止。 解决办法： 1.打开计算机的任务管理器 2.点击“服务”模块，找到MySQL右击启动即可 3.重启启动本地项目，正常运行 ...
MySQL--连接超时提示：The driver has not received any packets from the server
热门推荐
JustinQin
11-25 8万+
今天访问部署在Linux上Tomcat一直跑着的项目时，报错了，查看Tomcat日志大致报错信息提示...last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. 大概意思就是跑的项目的与mysql服务器连...
The driver has not received any packets from the server.（linux中关于mysql相关命令）
a1290320893的博客
12-27 2295
原因：呃呃、重启服务器，没有重新启动mysql; linux中关于mysql相关命令 1、检查MYSQL是否已安装：yum list installed | grep mysql 2、查看mysql安装目录：whereis mysql 3、启动linux服务器中mysql命令： systemctl start mysqld systemctl enable mysqld systemctl status mysqld 3、进入mysql：mysql -uroot -p the last packet s
sct.rar_The Network_content firewall
09-24
对防火墙中的数据包进行协议还原,检测网络数据包的原始内容The firewall in the agreement to restore the packets to detect network packets of the original content
xt_NOTRACK.rar_On the Up_conntrack
09-24
This is a module which is used for setting up fake conntracks on packets so that they are not seen by the conntrack/NAT code for linux.
wangluofengbao.rar_The Novice
09-24
网络封包研究 适合新手,里面介绍进制的关系抓包封包转发Network packets that suit the novice, which capture the relationship between the introduction hexadecimal packet forwarding
pcap.cr：libpcap的水晶绑定
02-05
pcap.cr：libpcap的水晶绑定
snmp.zip_The Program
09-23
this is a java program for scanning the packets in the system that is transferring using the snmp ie simple network management protocol , this is similar to the network sniffer
oom.rar_Out Of The Blue
09-23
This is the global socket data structure used for responding to the Out-of-the-blue (OOTB) packets. A control sock will be created for this socket at the initialization time.
mysql 错误：The driver has not received any packets from the server.
默默不代表沉默
05-15 3万+
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 fr...
The driver has not received any packets from the server.)
01-05
根据提供的引用内容，"The driver has not received any packets from the server."错误是由于连接被拒绝导致的。这通常是由于以下几个原因引起的： 1. 服务器未启动或未响应：请确保服务器已经启动并且正在运行，并且可以通过网络访问。 2. 防火墙或网络问题：检查防火墙设置，确保允许与服务器的通信。还要确保网络连接正常，没有任何问题。 3. 错误的连接参数：请检查连接参数，包括主机名、端口号、用户名和密码等，确保它们正确无误。 4. 数据库配置问题：检查数据库的配置文件，确保数据库已正确配置并且可以接受连接。 以下是一个示例代码，演示了如何处理这个错误： ```java import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class DatabaseConnection { public static void main(String[] args) { String url = "jdbc:mysql://localhost:3306/mydatabase"; String username = "root"; String password = "password"; try { Connection connection = DriverManager.getConnection(url, username, password); System.out.println("Connected to the database!"); // 执行其他操作... } catch (SQLException e) { System.out.println("Failed to connect to the database: " + e.getMessage()); } } } ```

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值