How to connect to mysql server on a web server remotely
How to connect to mysql server on a web server remotely
I am using MyDAC but can't connect a remote server. I tried locally making server property is localhost and was succesful. But I need to reach to the data on our web server. How can I do this?
You need to be sure that you have privileges to access that server, and if it's a WAN/Internet connection, then the port 3306 has to be opened on router to that server machine. I had experience with two ISP, one has port open for users, other one not and for security reasons don't want to open (I don't know why, it's safe).