1
I have two remote dedicated servers, one webserver that runs Apache, and one db server that runs MySQL.
The Apache server is visible on the Internet of course, but the second server is visible only to the Apache server because they are connected with LAN.
I need to connect to the remote MySQL server through Internet from my home-pc, but only Apache server is visible to my home-pc. How can I set up port-forwarding from my Apache server to the MySQL server so I will be able to "see" the MySQL server from my home-pc?
This question is a follow-up from my first question: https://stackoverflow.com/questions/4159256/connect-to-remote-mysql-server-from-my-application-problem-is-that-mysql-server in which you answered me and helped me a lot by telling me to do "port-forwarding".
I looked over the Internet, and I can't find a good how-to to do port-forwarding. I'm an experienced programmer, but have little experience on hardware and networks. I can understand though what must be done, so I just need a little help to sort things out. :)
P.S. The machine that Apache is running is on CentOS; the MySQL server also runs CentOS. P.S.2 webserver runs WebHostManager. I don't know if that makes any difference or it can be made easily through this, I just mention it.
1This should be asked on serverfault – rwilliams – 2010-12-02T10:27:20.643
How do you intend to connect to your mysql server? Web? Navicat? Command line? – Andreas Wong – 2010-12-02T10:29:01.007