《Mysql應用MySql的Communications link failure解決辦法》要點：
本文介紹了Mysql應用MySql的Communications link failure解決辦法，希望對您有用。如果有疑問，可以聯系我們。

在使用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";

轉載請注明本頁網址：
http://www.snjht.com/jiaocheng/5590.html