How to connect remote MySQL via Apache and SSL?
I have MySql installed on my server and I am using Apache as a proxy server to my Tomcat. I have SSL certificate installed. My current configuration is,
Apache :443 port requests ---- direct to-----> tomcat :8080
Apache :80 port requests -----direct to -----> web site
MySql installed and listening to default port 127.0.0.1:3306
So I have apache in front of everything and accepting :443 secure and :80 connections only.
I am trying to connect to my MySQL server remotely so any idea how can I do with SSL or without (i don't prefer)
I have tried such solution below but it seems not working.
- I have configured Apache to listen also 444 port for SSL
- I have defined another virtual host on Apache to direct requests coming from 444 port to 127.0.0.1:3306