Connection between Java and MYSQL server

Question

I know that this issue has been discussed a lot of times but I cannot establish a connection between my Java app and MySQL server.

I'm using code form tutorials:

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class JDBCTest{
  private Connection conn = null;
  public void connect(){
    try {
      Class.forName("com.mysql.jdbc.Driver").newInstance();
      System.out.println("test");
      conn = DriverManager.getConnection("jdbc:mysql://mysql.***.***.**:3306/******","*******","top_secret_password");
      System.out.println("test2");


    } catch (SQLException ex) {
      // handle any errors
      System.out.println("SQLException: "   ex.getMessage());
      System.out.println("SQLState: "   ex.getSQLState());
      System.out.println("VendorError: "   ex.getErrorCode());
    }catch(Exception e){e.printStackTrace();}   
  }

}

Error that occured is:

test
SQLException: 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.
SQLState: 08S01
VendorError: 0

Have you got any ideas how fix it?

Looks like an exact duplicate of stackoverflow.com/questions/2121829/… — Barend
– Barend, Commented Mar 31, 2012 at 7:25

ruhungry · Accepted Answer · 2014-03-27 22:18:42Z

2

Try to provide the IP-address of the database instead of its name. Say

conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/*******","*******","top_secret_password");

and make sure that your firewall doesn' block 3306 port

edited Mar 27, 2014 at 22:18

ruhungry

4,71621 gold badges58 silver badges99 bronze badges

answered Mar 31, 2012 at 7:59

Alex Stybaev

4,7133 gold badges32 silver badges44 bronze badges

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

Collectives™ on Stack Overflow

Connection between Java and MYSQL server

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related