JDBC连接不上虚拟机中的mysql?

授权了远程访问 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端口没?