授权了远程访问 navicat能连接 5和8都试过都不行
报错信息
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://192.168.137.128:3306/springboot?userSSL=false";
String user = "root";
String password = "time200311";
conn = DriverManager.getConnection(url,user,password);
String sql = "select * from t_student";
stmt = conn.prepareStatement(sql);
ResultSet rs = stmt.executeQuery();
while (rs.next()){
System.out.println(rs.getString("name"));;
}
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
The last packet successfully received from the server was 786 milliseconds ago. The last packet sent successfully to the server was 777 milliseconds ago.
应该是虚拟机没连上网,建议把虚拟机的桥连接打开,ping一下虚拟机的ip
你的JDBC数据库连接参数是什么?还有就是你的MySQL版本是多少?
把你的Java代码贴一下。
您好,我是有问必答小助手,您的问题已经有小伙伴解答了,您看下是否解决,可以追评进行沟通哦~
如果有您比较满意的答案 / 帮您提供解决思路的答案,可以点击【采纳】按钮,给回答的小伙伴一些鼓励哦~~
ps:问答VIP仅需29元,即可享受5次/月 有问必答服务,了解详情>>>https://vip.csdn.net/askvip?utm_source=1146287632
开放服务器的3306端口没?