How to successfully access the database on another computer using java and jdbc and sql?

Question

i have this database on another pc and i want to access it by using a connection string like this.

Class.forName("com.mysql.jdbc.Driver");
         con = DriverManager.getConnection("jdbc:mysql://192.168.0.1/dbtina","root","1234");

the "dbtina" is our database. the "1234" is our password. and we have configured our ip to be like that because we are using a wired connection (peer to peer).

Exception: Communications link failure

Last packet sent to the server was 0 ms ago.*

how do i fix this?

Bhavik Shah · Accepted Answer · 2012-10-15 05:18:50Z

3

Simply disable firewall. or open the port 3306 for mysql use this link if it helps

manually open port

even after doing this you might get security exception. use mysql GRANT query to give permissions.

mysql> GRANT ALL PRIVILEGES ON db_base.* TO db_user @'ip_address' IDENTIFIED BY 'db_passwd';

grant example

answered Oct 15, 2012 at 5:18

Bhavik Shah

5,1933 gold badges26 silver badges40 bronze badges

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

Comments

ppeterka · Accepted Answer · 2012-10-14 19:49:36Z

2

Open the 3306 port on the firewall of the computer where the DB is.

answered Oct 14, 2012 at 19:49

ppeterka

20.8k6 gold badges67 silver badges80 bronze badges

1 Comment

ppeterka Over a year ago

Well, first of all, you could provide some details...What OS are you using on the computer with the DB? What kind of firewall or antivirus software are you using there? Judging by your comment, I'd also like to ask what's the IP of the computer where the program is run...

greatmajestics · Accepted Answer · 2012-10-14 19:46:37Z

1

You have to configure the firewall on the database computer to allow the traffic from different computer on specific Port.

answered Oct 14, 2012 at 19:46

greatmajestics

1,0934 gold badges19 silver badges41 bronze badges

Comments

Laurel · Accepted Answer · 2016-07-15 21:18:59Z

1

GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'%' IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION;

edited Jul 15, 2016 at 21:18

Laurel

6,23114 gold badges35 silver badges60 bronze badges

answered Jul 15, 2016 at 13:13

Manas Maity

111 bronze badge

Comments

mathielo · Accepted Answer · 2016-01-25 14:13:27Z

-1

Change your code accordingly:

Class.forName("com.mysql.jdbc.Driver");         
con = DriverManager.getConnection("jdbc:mysql://192.168.0.1:3306/dbtina",
  "root","1234");

edited Jan 25, 2016 at 14:13

mathielo

6,7757 gold badges53 silver badges64 bronze badges

answered Jan 25, 2016 at 13:49

Ajay Singh Meena

659 bronze badges

Collectives™ on Stack Overflow

How to successfully access the database on another computer using java and jdbc and sql?

5 Answers 5

Comments

1 Comment

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related