How to connect to mysql server on a web server remotely

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
selim

How to connect to mysql server on a web server remotely

Post by selim » Thu 13 Jan 2005 09:33

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?

GEswin
Posts: 186
Joined: Wed 03 Nov 2004 16:57
Location: Spain
Contact:

Post by GEswin » Thu 13 Jan 2005 10:28

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).

Post Reply