How to setup port forwarding from my Webserver (apache) to my Database server (mysql)
- by karman888
Hello again guys, and thank you for your help so far.
Here is my problem:
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 only visible 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 setup 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 Connect to remote mysql server from my application. Problem is that Mysql server is on LAN
in which you answered me and helped me a lot by telling me to do "port-forwarding".
I looked over the internet, and i cant 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 litle help to sort things out :)
I hope you can help me guys,
Thank you in advance
p.s. machine that Apache is running is on CentOS, mysql server also CentOS.
p.s2 webserver runs WebHostManager i dont know if that makes any difference or it can be made easily through this, i just mention it :)