Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
jahanzaib niazi
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Sheriff
Posts: 21572
33
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic