I'm newbie with server/client communication. I developed a java application whose database is at MySQL Server localhost. i'm connection with it using Jdbc. Can anyone tell me what i do to connect that application as a client and run MYSql on other computer/server. Guide me to the path. where i communicate multiple client applications with MySQL server.
Asked
Active
Viewed 140 times
0
-
1You use the machine's ip adress instead of localhost. You also need to make sure your mysql server allows connections from other hosts. And the mysql port (3306) needs to be open (in your router or firewall) to the machines that try to connect to it. – f1sh Dec 22 '16 at 15:24
-
but what if i don't install mysql on server in development mode. because some where i read that you have to install mysql in development mode to do this tacsk. – Junaid Dec 22 '16 at 15:50
-
What is development mode? You simply install mysql on a server and connect to it using the server's ip address. – f1sh Dec 22 '16 at 15:56
-
look into this same question http://stackoverflow.com/questions/8348506/grant-remote-access-of-mysql-database-from-any-ip-address – Chandra Dec 22 '16 at 17:59