Java application : accessing database on a different computer

Question

I have an application that uses java se and while coding it I installed mysql workbench on localhost, everything works fine. Now I have to distribute the jar files so that people can use it. but when I try accessing the database it says connection error. In the database path I replaced localhost with the ip of the computer the database is on. Could someone please help me out.

Thanks a lot

you need to be able to ping or telnet the database server to make sure you can connect, have you tried to? — Oleg Mikheev
– Oleg Mikheev, Commented Feb 19, 2012 at 4:42
@Santosh Yeah i think thats the problem in the users window it says localhost ... how do i make it accessible from any ip? — koool
– koool, Commented Feb 19, 2012 at 4:48
@Qwe - excellent suggestion. Koool - you should be able to "telnet YOUR-HOST 3306" to verify the MySql port is open between the client and the remote MySql server. — paulsm4
– paulsm4, Commented Feb 19, 2012 at 4:52

paulsm4 · Accepted Answer · 2012-02-19 04:46:29Z

1

As you know, for JDBC in general, you need to specify the host in your connection string.
As you also know, you typically specify the driver in Class.forName(), and the driver's .jar directory in your Java CLASSPATH.
You're probably using the MySql/J connector - I believe that's all your client needs deployed along with your application.
You also need to make sure the mySql port (default 3306) is open.
Mysql "users" are defined and authorized on a per-host basis. You'll also need to make sure this is set up correctly in your "Users" mysql table.
Be sure your application logs all available exception information. Please post any specific error messages here.

'Hope that helps

PS: The only relevance to "mysql workbench" is that your app happens to work when you run it locally, using mysql workbench, correct? If so, it probably isn't a good tag for this question...

answered Feb 19, 2012 at 4:46

paulsm4

123k23 gold badges175 silver badges245 bronze badges

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

1 Comment

koool Over a year ago

1. check 2. Class.forName("com.mysql.jdbc.Driver"); 3. done 4. done

Santosh · Accepted Answer · 2012-02-19 05:10:19Z

1

Run the query on the DB as admin user.

GRANT ALL ON db1 TO 'jeffrey'@'%';

Assuming that db1 is your schema and jeffrey is the user you want to give access to.

edited Feb 19, 2012 at 5:10

answered Feb 19, 2012 at 4:58

Santosh

18k4 gold badges58 silver badges80 bronze badges

3 Comments

koool Over a year ago

so if i have this code in my app con = DriverManager.getConnection( "jdbc:mysql://ip/db1?"+"user=jeffrey&password="); it should work right?

koool Over a year ago

from above comments I tried to ping and it says request failed what would be a solution to that??

Santosh Over a year ago

You mean you cannot ping the machine which has database ?

Collectives™ on Stack Overflow

Java application : accessing database on a different computer

2 Answers 2

1 Comment

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related