What should be the connection URL

[Mahesh Lohi]

Hi all,

I use two systems. I have placed the DB in one of the system(server) and would like to insert and select data from the second system.

my connection is String url=("jdbc:mysql://localhost:3306/warehouse?"+"user=root&password=123456");

Now what should I change my url string to, so that I can access the warehouse database via the client system

Thank you in advance

[Ulf Dittmer]

You'd replace "localhost" by the name (or IP address) of the DB server, "3306" by the port number on which the server is listening, "warehouse" by the name of the DB schema you want to access, "root" by the username, and "123456" by the user's password.

[Mahesh Lohi]

Thank you for the quick response.. is DB schema different from my db name

Thank you in advance

[Ulf Dittmer]

No, that's the same.