I only see an SSL option on the install, however I need SSH. The DB is installed on a remote server as localhost so an SSH tunnel needs to be established to connect.
How to install over SSH (not SSL)(2 posts) (2 voices)
I only see an SSL option on the install, however I need SSH. The DB is installed on a remote server as localhost so an SSH tunnel needs to be established to connect.Posted 4 months ago #
If you have the database server on different server than the web server and you want to use SSH (direct database access not allowed), you need to establish a SSH tunnel between the servers. To do this, forward a port from web server to the database server. This is done at OS level:
ssh -L 3306:127.0.0.1:3306 firstname.lastname@example.org
This will open up SSH connection to remoteserver.com using username myusername. All traffic on localhost (127.0.0.1) to port 3306 (the one after -L) will be forwarded to remote server's MySQL port 3306. This assumes you do not have MySQL Server running on the web server. If you do, choose another port.
myDBR TeamPosted 4 months ago #
You must log in to post.