首页 > > 网络编程 > Mysql >

MySql的Communications link failure解决办法

2018-06-17 23:39:40来源：未知阅读 ()

在使用JDBC连接mysql时可能会遇到以下错误：

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

解决方法：

将

String url = "jdbc:mysql://192.168.xxx.xxx:3306/db";

此处的IP部分添加到hosts文件中，并使用hosts中设置的名称进行连接。

例：

String url = "jdbc:mysql://127.0.0.1:3306/db";

变为

String url = "jdbc:mysql://localhost:3306/db";

练习一下英语：

This error may encountered when using JDBC to connect Mysql:

　　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

sulotions:

You need add target IP to your hosts file and name it.

make String url = "jdbc:mysql://192.168.xxx.xxx:3306/db"; be String url = "jdbc:mysql://hostname:3306/db";

example：

String url = "jdbc:mysql://127.0.0.1:3306/db";

change to

String url = "jdbc:mysql://localhost:3306/db";

标签：

版权申明：本站文章部分自网络，如有侵权，请联系：west999com@outlook.com
特别注意：本站所有转载文章言论不代表本站观点，本站所提供的摄影照片，插画，设计作品，如需使用，请与原作者联系，版权归原作者所有

热门词条

最新资讯

热门关注

热门标签