failed to connect to MySql from java

Question

i want to open a MySql connection from java. and this my code :

public static void main(String [] args){
    String line;
    Connection connection;
    Statement statement;
    Class.forName("com.mysql.jdbc.Driver").newInstance();
        connection=DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "manager");
        statement =connection.createStatement();

        System.out.println("Database Created...!!!");
        System.out.println("Connected");


}

but it give me this error:

    com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

    Last packet sent to the server was 1 ms ago.
        ...
Caused by: java.net.ConnectException: Connection timed out: connect

why? and what it should be do? please help me. thank you...

Check This stackoverflow.com/questions/2839321/… and stackoverflow.com/questions/2983248/… — Shyam
– Shyam, Commented Sep 24, 2013 at 7:24

SpringLearner · Accepted Answer · 2013-09-24 07:14:38Z

1

This is because your mysql might not be running. Try to telnet by telnet 127.0.0.1 3306 If you get error then mysql is not running for sure. you can also check

netstat -aon | find /i "listening"

this will show all listening ports

answered Sep 24, 2013 at 7:14

SpringLearner

13.9k20 gold badges82 silver badges117 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

ooo Over a year ago

the mysql server is running successfully but the same error it appear in java

SpringLearner Over a year ago

@ooo I think you are using windows 7 and in this OS telnet is by default disabled.You need to enable it first

Stanley Stein · Accepted Answer · 2013-09-24 07:46:35Z

0

It is the connection problem between the driver and the server. Please ensure that the driver version and the server version match. For example, if your server version is MySQL 4.0 or 3.23, you should use mysql-connector-java-3.0.11-stable-bin.jar instead of the latest version.

answered Sep 24, 2013 at 7:46

Stanley Stein

3971 gold badge5 silver badges19 bronze badges

5 Comments

ooo Over a year ago

my server version is " 5.1.50-community " witch mysql connector should be download/?

Stanley Stein Over a year ago

Refering link Table 20.22. Summary of Connector/J Versions Connector/J version Driver Type JDBC version MySQL Server version Status 5.1 4 3.0, 4.0 4.1, 5.0, 5.1, 5.5, 5.6, 5.7 Recommended version 5.0 4 3.0 4.1, 5.0 Released version 3.1 4 3.0 4.1, 5.0 Obsolete 3.0 4 3.0 3.x, 4.1 Obsolete

Stanley Stein Over a year ago

1. Could you utilize the default mysql client (i.e. mysql) to access the local database "test" by the same username and the password? 2. Could you try to stop the local firewall if possible?

ooo Over a year ago

i'm developing a java web application in which it should be desplay the my sql open session,so i want access on mysql to show the open sessions

Stanley Stein Over a year ago

Could you try to do the two steps I suggested? as I suspected that test was not accessible.

Collectives™ on Stack Overflow

failed to connect to MySql from java

2 Answers 2

2 Comments

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related