Connecting to MySQL using jdbc driver

Question

I created a class called BD in which i try to establish a connection with a database called bono

public class BD {
String url,login,password,driver;
Connection conexion=null;

public BD(){
    driver = "com.mysql.jdbc.Driver";
    url = new String("jdbc:mysql://localhost:8000/bono");
    login = new String("root");
    password = new String("mypassword");
    try {
        Class.forName(driver);
        conexion = DriverManager.getConnection(url, login, password);
        System.out.println("Conexi�n con Base de datos Ok....");
    } catch (ClassNotFoundException e) { // 
        System.out.println("error 1");
    } catch (SQLException e) {
        System.out.println("error 2");
    }
}

but when i execute it, it just stays in this following line:

conexion = DriverManager.getConnection(url, login, password);

it doesn't send any errors nor does it establish the connection. What should i do?

or simply remove the port part, like jdbc:mysql://localhost/bono — bananas, May 12 '16 at 05:27

OscarBcn · Answer 1 · 2016-05-12T05:46:06.750

try changing your port to 3306.

public class BD {
String url,login,password,driver;
Connection conexion=null;

public BD(){
    driver = "com.mysql.jdbc.Driver";
    url = new String("jdbc:mysql://localhost:3306/bono");
    login = new String("root");
    password = new String("mypassword");
    try {
        Class.forName(driver);
        conexion = DriverManager.getConnection(url, login, password);
        System.out.println("Conexi�n con Base de datos Ok....");
    } catch (ClassNotFoundException e) { // 
        System.out.println("error 1");
        e.printStackTrace();
    } catch (SQLException e) {
        System.out.println("error 2");
        e.printStackTrace();
    }
}

Hope it helps.

Note: be sure that MySQL is running. Try something like: mysqladmin -u root -p status from your console, there shouldn't display any error

try also adding the exception message to the error message – Scary Wombat May 12 '16 at 05:12 — Scary Wombat, May 12 '16 at 05:12
Sure, you are right, those are added now – OscarBcn May 12 '16 at 05:46 — OscarBcn, May 12 '16 at 05:46

score 2 · Answer 2 · answered May 12 '16 at 05:24

i think your port maybe incorrect: try this code hopefully at least you see some exception

public class BD {
String url,login,password,driver;
Connection conexion=null;

public BD(){
    driver = "com.mysql.jdbc.Driver";
    url = new String("jdbc:mysql://127.0.0.1:3306/bono");
    login = new String("root");
    password = new String("mypassword");
    try {
        Class.forName(driver);
        conexion = DriverManager.getConnection(url, login, password);
        System.out.println("Ok....");
    } catch (ClassNotFoundException e) { // 
        e.printStackTrace();
    } catch (SQLException e) {
        e.printStackTrace();
    }
}

Connecting to MySQL using jdbc driver

2 Answers2