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
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.×