求大神抽时间看看，java连接本地mysql数据库出现connection reset错误

Question

小弟弄这个小问题弄了好久，通过各种渠道找方法最后实在是没有办法了，望大神抽时间帮忙看看，谢谢
代码如下
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class MysqlConnection {
public static void main(String[] args) {
try {
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://localhost:3306/test";
Connection con=DriverManager.getConnection(url, "root","");
Statement stmt=con.createStatement();
String sql="select * from msg";
boolean m=stmt.execute(sql);
if(m){
System.out.println("succ");
}else
System.out.println("false");
} catch (ClassNotFoundException e) {

                            e.printStackTrace();
                } catch (SQLException e) {

                            e.printStackTrace();
    } 
}

}
出现如下错误：
com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: Connection reset

STACKTRACE:

java.net.SocketException: Connection reset
at java.net.SocketInputStream.read(Unknown Source)
at java.net.SocketInputStream.read(Unknown Source)
at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:105)
at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:148)
at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:176)
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1899)
at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:481)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:964)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2544)
at com.mysql.jdbc.Connection.(Connection.java:1474)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:264)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.iotek.mysql.MysqlConnection.main(MysqlConnection.java:16)

** END NESTED EXCEPTION **

Last packet sent to the server was 27 ms ago.
at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:552)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:964)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2544)
at com.mysql.jdbc.Connection.(Connection.java:1474)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:264)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.iotek.mysql.MysqlConnection.main(MysqlConnection.java:16)

Answer 1

看下你的防火墙是不是阻止了3306端口，或者你的mysql没有运行起来。