Topic: I have built a Java Desktop Application using NetBeans and It uses MySQL as the database.It works perfectly fine. But,I want to host the database on an online remote server instead of storing on my c
I have built a Java Desktop Application using NetBeans and It uses MySQL as the database.It works perfectly fine. But,I want to host the database on an online remote server instead of storing on my computer locally. So that any ordinary user can use my app without needing to install MySQL for this I googled but couldn't find any tutorials on this. Please help me out how to connect to a remote server using jdbc.
Author: RANJIT
Not sure what course is right for you?
Choose the right course for you.Get the help of our experts and find a course that best suits your needs.
Let`s Connect
JOSHUA
If you have a paid server hosting and have a cpanel, you can create your database in the server and then set access to MySQL from any host (for security reasons the default is only localhost). Then change the connection parameters in your code that match the parameters in the server (domain name instead of IP, db name in the server, and password) .See this link https://my.bluehost.com/hosting/help/89 It may help you further.
VAMSI
@ Ranjit Put your business logic on the remote server as a rest service. Or configure your code so that it connects to a remote db