The driver has not received any packets from the server.（linux中关于mysql相关命令）

最新推荐文章于 2024-08-22 03:58:16 发布

java请多指教

最新推荐文章于 2024-08-22 03:58:16 发布

阅读量2.5k

点赞数 1

CC 4.0 BY-SA版权

分类专栏： # Mysql 文章标签： mysql linux 服务器

本文链接：https://blog.csdn.net/a1290320893/article/details/122178571

本文介绍了在Linux系统中遇到‘The driver has not received any packets from the server.’错误的原因，可能是因为MySQL未重启或者3306端口未开放远程连接。解决方案包括重启MySQL服务，以及在防火墙中开启3306端口。同时提供了检查MySQL安装、启动MySQL服务以及使用mysql命令行的步骤。

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

原因：
1、呃呃、重启服务器，没有重新启动mysql;
2、如果还不能连接可能是3306是不允许进行远程连接的，所以在防火墙中设置3306开启远程服务； /sbin/iptables -I INPUT -p tcp --dport 3306 -j ACCEPT

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 sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
### The error may exist in com/example/finalspringsecurity/mapper/UserMapper.java (best guess)
### The error may involve com.example.finalspringsecurity.mapper.UserMapper.selectOne
### The error occurred while executing a query
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is 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 org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92) ~[mybatis-spring-2.0.5.jar:2.0.5]
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440) ~[mybatis-spring-2.0.5.jar:2.0.5]
	at com.sun.proxy.$Proxy55.selectOne(Unknown Source) ~[na:na]
	at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:159) ~[mybatis-spring-2.0.5.jar:2.0.5]
	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:90) ~[mybatis-plus-core-3.4.1.jar:3.4.1]
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148) ~[mybatis-plus-core-3.4.1.jar:3.4.1]
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89) ~[mybatis-plus-core-3.4.1.jar:3.4.1]
	at com.sun.proxy.$Proxy59.selectOne(Unknown Source) ~[na:na]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_201]
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_201]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_201]
	at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_201]
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344) ~[spring-aop-5.3.1.jar:5.3.1]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198) ~[spring-aop-5.3.1.jar:5.3.1]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.