Victor Ikenna Victor Ikenna - 1 year ago 133
MySQL Question

Java Remote Connection

Assuming I have this Connection String on my local host:

public static Connection ConnectDB(){
Connection con = DriverManager.getConnection("jdbc:mysql://localhost/supermarket", "root","");
return con;

When I am trying to Connect to this system from another. What should I change to access the database?

Say my IP Address on the system is :

Answer Source

your statement would become

Connection con = DriverManager.getConnection("jdbc:mysql://<IP Address>:<Port>/supermarket", "root",""); 

Use appropriate IP and Portnumber

Connection con = DriverManager.getConnection("jdbc:mysql://‌​/supermarket", "root",""); 
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download