How to specify my databases name into JDBC -> MySQL connection?

Question

What is the way to connect with JDBC to a mySql database that is online?

mysql.info.mi.us:3006 = corresponds to the server of the database

mydatabases_2 = my databases

my try returning this error:

java.lang.NullPointerException

Class.forName("com.mysql.jdbc.Driver")
connexion = DriverManager.getConnection("jdbc:mysql://mysql.info.mi.us:3306", "user", "password");

The problem has nothing to do with your JDBC connection. You have a NullPointerException because something is not initialized. We are able to hack into your computer to solve the problem, but choose not to do so. Instead, consider posting the exception output. — DwB
– DwB, Commented Nov 14, 2017 at 15:31

Stefan · Accepted Answer · 2017-11-14 15:11:36Z

2

Just append it:

connexion = DriverManager.getConnection("jdbc:mysql://mysql.info.mi.us:3006/mydatabases_2", "user", "password");

answered Nov 14, 2017 at 15:11

Stefan

2,2142 gold badges20 silver badges29 bronze badges

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

2 Comments

always the same error "java.lang.NullPointerException"

U sure you are using the right port? sql db's tend to be on 3306 instead of 3006

kekolab · Accepted Answer · 2017-11-14 15:26:48Z

0

Just a question: are you sure about the port? The default port of mysql is 3306, while you're using 3006. Are you sure the port is right?

answered Nov 14, 2017 at 15:26

kekolab

83110 silver badges25 bronze badges