Just a quick note for me to easily find and remember how to access PHP My Admin on a Bitnami WordPress instance
From the command line on my local machine:
ssh -4 -N -L 8888:www.gerisch.org:443 -i $insertpathtopemfilehere email@example.com
And then in a browser:
Lastly, remember that the login name to phpmyadmin is root (not the Bitnami application password, or any other user name).
Because public Internet access to PHP My Admin would be a Very Bad Idea, the Bitnami WordPress image is configured such that PHP My Admin refuses to run, if the requests don’t come through www.gerisch.org
This is a good idea.
But what that also means is that I need something listening on my www.gerisch.org address, that can forward the network traffic to the remote web server.
ssh -4 says use IP v4 addresses only (suppresses IP v6 errors if your machine doesn’t have that).
ssh -N says do not execute remote commands (all we’re going to be doing here is port forwarding).
ssh -L says local to remote port forwarding will be done.
8888:www.gerisch.org:443 says the local port to listen on is port 8888, the local address to listen on is the home address of www.gerisch.org, and when listening on the “server” www.gerisch.org, know that it will be listening for port 443 traffic (https instead of http). Another way of thinking about this is that your web browser that is throwing HTTP GETs and PUTs will be throwing them at port 8888, since that is the port the service is listening on. But when the traffic is thrown across the Internet, ssh is going to throw the traffic to www.gerisch.org port 443. Yet, www.gerisch.org:443 is really just a front for gerisch.org:443
ssh -i says to use a public/private key pair for logging in (instead of a password). $insertpathtopemfilehere is the variable that holds the path to the .pem file.
ssh firstname.lastname@example.org is the actual remote login name and server name.