Can't connect to godaddy MySQL with java

Question

I'm trying to connect to a mysql db, but I keep getting error: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

I know the url suppose to be: "jdbc:mysql://server-url:3306"

here is the code:

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

public class FT_Database_Connection{
private Connection connection;

public FT_Database_Connection(String url, String username, String password){
    try{
        System.out.println("Loading driver...");
        Class.forName("com.mysql.jdbc.Driver");
        System.out.println("Driver loaded!");

        String user = username;
        String db_pw = password;
        System.out.println(url);
        System.out.println(username);
        System.out.println(password);
        Connection test = DriverManager.getConnection(url, user, db_pw);

    }catch(Exception e){
        System.out.println("Couldn't get database connection.");
        e.printStackTrace();
    }
}

public Connection get_connection(){
    return this.connection;
}

}

Any ideas?

Also, Godaddy ask if I want DSN. What's that mean? Do I need it?

Thanks

I can't look up GoDaddy at work, but somewhere in that URL string has to be something that identifies the MySQL database as your MySQL database. server-url is too generic. — Gilbert Le Blanc
A lot depends on your GoDaddy configuration. Typically, they restrict connections to their database servers to their internal networks only. So if you're not running your Java code on a GoDaddy server, you may have issues connecting through their firewall. — jtv4k

sfell77 sfell77 · Accepted Answer · 2012-10-03T18:33:28

You need to put your database name after the MySQL port (:3306/DB_name). Here's one of my connections:

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

public class MySQL{

    static Connection connect;
    public static void main(String[] args) throws InstantiationException, IllegalAccessException, ClassNotFoundException, SQLException {
    Credentials();

    Class.forName ("com.mysql.jdbc.Driver").newInstance ();

    String url = "jdbc:mysql://" + host + ":3306/" + datab;

    Driver test = DriverManager.getDriver(url);
    // testing to make sure i'm using the correct
    //driver and further testing host
    System.out.println(test);
    connect = DriverManager.getConnection(url, userName, password);

    System.out.println ("Connected to " + host);
    }
}

You'll need to supply the "host" and "datab" string values

Can't connect to godaddy MySQL with java

3 Answers