JAVA-服务启动报错The last packet sent successfully to the server was 0 milliseconds ago.

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.
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
	at java.lang.reflect.Constructor.newInstance(Unknown Source)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
	at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:989)
	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:341)
	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2196)
	at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2229)
	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2024)
	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:779)
	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
	at java.lang.reflect.Constructor.newInstance(Unknown Source)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:389)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at com.ad.MysqlDemo.main(MysqlDemo.java:32)
Caused by: java.net.ConnectException: Connection refused: connect
	at java.net.DualStackPlainSocketImpl.connect0(Native Method)
	at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
	at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
	at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
	at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
	at java.net.PlainSocketImpl.connect(Unknown Source)
	at java.net.SocksSocketImpl.connect(Unknown Source)
	at java.net.Socket.connect(Unknown Source)
	at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:211)
	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:300)
	... 15 more
Exception in thread "main" java.lang.NullPointerException
	at com.ad.MysqlDemo.main(MysqlDemo.java:57)

检查下datasource数据源的配置,可能是数据库没有启动,连接不上.

如果Navicat也连不上mysql,需要去修改下mysql的配置文件my.cnf

bind-address = 127.0.0.1
改为 bind-address = 0.0.0.0

然后重启mysql

启动报错"The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server."通常是数据库连接问题引起的。这个错误提示表明在与数据库建立连接时出现了问题,可能是由于网络连接不稳定或数据库服务未正常启动导致的。在使用数据库驱动程序进行通信时,如果发生了丢包或连接中断的情况,就会出现这个错误提示。为了解决这个问题,可以尝试以下几个步骤: 1. 检查网络连接:确保您的网络连接稳定,并且能够正常访问数据库服务器。如果网络连接不稳定,可以尝试重新连接或者重新启动网络设备。 2. 检查数据库服务:确保数据库服务已经正确启动,并且可以正常响应请求。您可以使用命令行工具或者管理界面来检查数据库的运行状态。 3. 检查数据库配置:检查数据库连接配置是否正确,包括数据库地址、端口号、用户名和密码等信息。确保这些配置与数据库服务器的配置一致。 4. 检查防火墙设置:如果您的系统上有防火墙,确保数据库服务器的端口没有被防火墙屏蔽。您可以尝试暂时关闭防火墙或者配置防火墙规则来允许数据库连接。 如果以上步骤都没有解决问题,还可以尝试重新启动应用程序或者重新安装数据库驱动程序。如果问题仍然存在,建议您查看具体的错误日志或者咨询相关技术支持人员以获取更详细的帮助。<span class="em">1</span><span class="em">2</span><span class="em">3</span> #### 引用[.reference_title] - *1* [The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received](https://blog.csdn.net/mmzzy20150928/article/details/125396419)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 33.333333333333336%"] - *2* [springboot启动异常[ The last packet sent successfully to the server was 0 milliseconds ago....](https://blog.csdn.net/a249040113/article/details/81700498)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 33.333333333333336%"] - *3* [docker-app-template:带有节点,React和Postgresql服务器的docker应用模板](https://download.csdn.net/download/weixin_42103128/16790862)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 33.333333333333336%"] [ .reference_list ]
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值