连接MySQL数据库时出现The dirver has not received any packets from the server
来源:互联网 发布:windows 9 编辑:程序博客网 时间:2024/06/05 17:26
看到网上很多很多的论坛与博客,终于找到我的错误的原因,先上图吧,
使用Connector/J连接MySQL数据库:Communications link failure,The last packet successfully received from the server was *** millisecond ago.The last packet successfully sent to the server was *** millisecond ago。 这个错误的话,是因为你超过了MySQL的默认闲置时间,要到mini上面改下参数,但是问题的关键不在我,我的错误是:CommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driv
er has not received any packets from the server.
解决方法:把Connetion URL=jdbc:mysql://127.0.0.1:3306/mysong
结论:一般而言,默认情况下,root好像只可以通过localhost访问,ip是不可以的,是没有权限,需要修改myslq配置文件。如果数据库和你部署的服务器是用一台机器,那么使用localhost没有问题,要是不在同一台,可能需要改mysql配置,保证ip可以访问。
0 0
- 连接MySQL数据库时出现The dirver has not received any packets from the server
- 关于activiti连接数据库超时问题—— The driver has not received any packets from the server
- jdbc启动错误(The driver has not received any packets from the server)
- jdbc启动错误(The driver has not received any packets from the server)
- kettle错误:The driver has not received any packets from the server
- 数据库连接超时The driver has not received any packets from the server
- The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
- mysql重连,连接丢失:The last packet successfully received from the server
- mysql重连,连接丢失:The last packet successfully received from the server
- mysql重连,连接丢失:The last packet successfully received from the server
- mysql重连,连接丢失:The last packet successfully received from the server
- mysql重连,连接丢失:The last packet successfully received from the server--转载
- mysql重连,连接丢失:The last packet successfully received from the server--转载
- mysql重连,连接丢失:The last packet successfully received from the server--转载
- mysql重连,连接丢失:The last packet successfully received from the server
- mysql重连,连接丢失:The last packet successfully received from the server
- Spring连接mysql长时间空闲报错:The last packet successfully received from the server was xx millisecond ago...
- (2)Mysql ----- The last packet successfully received from the server was *** millisecond ago.The
- 从github下载最新Android源码
- kruskalMST
- FZU Problem 2146 Easy Game ( 数学啊)
- DLL中调用约定和名称修饰
- 11091 最优自然数分解问题(贪心)
- 连接MySQL数据库时出现The dirver has not received any packets from the server
- 社交招聘网络Linkedin的使用体验(HR招聘篇9)
- java正则表达式实例积累
- NSString去空格和换行
- IOS TextField设置大全
- 社交招聘网络Linkedin的使用体验(HR招聘篇10)
- 通过反射从数据库返回集合ResultSet中得到实体对象的list集合
- [python snippets] 邮件发送 (带附件,多收件人, 支持SMTP 和Postfix )
- 敏捷测试过程的度量标准---请记住,把度量作为一种激励的手段而不是打击士气的方式