How I can connect to another computer database in java?

Question

I connect by ip address from one pc to another pc database it work as well but how can I get connecting by java to this pc database
The database I used is mysql
And the server is xampp

Answer 1

My guess is you need to add the proper GRANT privileges which apply to the user / remote IP / and database.

You may also need to open your firewall on DB02 to allow remote connections on port 3306.

But... this is a wild guess since your question is so ambiguous.

Answer 2

Thanks from all of you
I changed my firewall port and then creat a new username and password it works well ❤️❤️

Answer 3

Arif Nasery

Step by step explanation is given here.

https://codeforgeek.com/java-mysql-connectivity-jdbc/

Answer 4

Arif Nasery The following are unclear from your question:

1. How exactly did you "connect by ip address from one pc to another pc database?"

Let's refer to these "PCs" as DB01 (MySQL) and APP01 (Java program). It will help keep things clearer.

2. When you tested your connection, was it from APP01 or another PC? If another PC is involved, let's refer to this as APP02.

3. Are you saying you were able to connect to a database on DB01, but you aren't able to connect to a database on another PC? If so, let's refer to the 2nd database as DB02.

4. Assuming there are two databases, one that you can connect to (DB01) and one you cannot (DB02), was your connection to DB01 from the Java program in question?

5. If this is about changing the connection for a Java program on APP01 from DB01 to DB02, have you attempted to connect to DB02 via MySQL Shell?

Answer 5

Arif Nasery
S-Adil 👑 🇦🇫 __active__

To connect your Java code with database (which is located at another IP) you have to define some inbound/outbound rules in firewall and also port number should be open means should be accessible from outside.

The procedure to connect java with database server is same as we have shared links but in that jdbc connection we have to provide IP address of database server (Remote PC where database exist)

Answer 6

https://www.javatpoint.com/example-to-connect-to-the-mysql-database

Answer 7

Arif Nasery
Just supply the IP / hostname of the remote machine in your database connection string, instead of localhost. For example:

jdbc:mysql://192.168.15.25:3306/yourdatabase
Make sure there is no firewall blocking the access to port 3306

Also, make sure the user you are connecting with is allowed to connect from this particular hostname. For development environments it is safe to do this by 'username'@'%'. Check the user creation manual and the GRANT manual.

visph
🅰🅹 🅐🅝🅐🅝🅣
Martin Taylor
You didn't understand what he means!

Answer 8

S-Adil 👑 🇦🇫 __active__ OP said he was able to connect from one pc to another one, so the problem is how to connect with java, not how to connect to another ip than localhost ^^

Answer 9

David Carroll yep true!

Answer 10

I try it but it's not working