在使用JDBC連接mysql時可能會遇到以下錯誤： com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet sent successfully to th ...
在使用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";
