How to connect to MySQL database using Java on another PC?

Asked Oct 24 '15 at 03:28

Active Oct 24 '15 at 03:28

Viewed 548 times

I have made a simple program that uses the connectivity String:

Class.forName("java.sql.DriverManager");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3305/project", "root", "xxxx");
Statement st = conn.createStatement();

Here 'project' is my database name and 'xxxx' is the password.

I have then created an .exe file that works fine on my own computer.

But how can other people on another computer use my program? Do they have to install MySQL? Or Can they access my computer's database on their computer?

asked Oct 24 '15 at 03:28

Vipul Kumar

Yeah you can you just need to replace `localhost` with `Your public IP`. And make sure the port is good. – 3kings Oct 24 '15 at 03:48
'com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure' – Vipul Kumar Oct 24 '15 at 03:55
I am getting this exception... – Vipul Kumar Oct 24 '15 at 03:55
http://stackoverflow.com/questions/6865538/solving-a-communications-link-failure-with-jdbc-and-mysql Peter John Joesph's Answer try that – 3kings Oct 24 '15 at 04:02

How to connect to MySQL database using Java on another PC?

0 Answers0