How to place mysql database on another system and application on another system

[jahanzaib niazi]

Hello friends i need a small help,
Friends i have developed a java desktop application in which i have used MYSQL database at the back end , database is on my local system.
But now i want that i want to place my database on another system and my application should be on another system. Then how could i connect with database which is on another system and database on another system???

[Paul Clapham]

Welcome to the Ranch!

As long as there's a network connection between the machines, there shouldn't be a problem. Your JDBC URL would just have to specify the name of the computer where the MySQL server is running along with the port it's listening on (normally 3306 I think). Presumably the JDBC URL has "localhost" for the computer name in your working code now.

You might run into problems if there's a firewall or a proxy or something like that blocking network connection between your application and the MySQL server, but don't worry about that until it actually becomes a problem.