mysql5.7项目不能连接的问题。项目不能连接

最新推荐文章于 2022-12-11 20:21:47 发布

尼古拉斯菜鸡

最新推荐文章于 2022-12-11 20:21:47 发布

阅读量4.9k

点赞数 1

分类专栏： mysql 文章标签： com.mysql.jdbc.excep

本文链接：https://blog.csdn.net/sinat_28849851/article/details/52181216

版权

本文记录了在项目中遇到的MySQL 5.7通信连接失败的异常，详细错误信息显示为`Communications link failure`。错误并非由于最大连接数或超时导致。解决方案包括彻底卸载并重新安装MySQL 5.7，注意开启防火墙端口，以及确保数据库配置使用`localhost`或`127.0.0.1`，而非本地IP。对于尚不了解的MySQL 5.7远程连接配置，作者提出待学习掌握后将在博客中分享。

摘要由CSDN通过智能技术生成

信息: Server startup in 20470 ms
2016-08-10 18:16:43,469 [org.logicalcobwebs.proxool.proxooldb]-[ERROR] Prototype
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:411)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:344)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2332)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2369)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2153)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792)
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.re