If you are using a Bitnami WordPress (multisite) stack like I am, your web-based database phpMyAdmin is setup by default to only be accessible if you are on the same machine (IP address of 127.0.0.1:80).
So in order to get access remotely, you have to trick your machine into thinking you are local. Thankfully there is some documentation on how to do all of this… but the following is a succinct summary.
- Beforehand, setup your .pem keyfile in your keychain, or add
-i path/to/your.pemin the following ssh command.
- In Terminal, type
ssh -N -L 8888:127.0.0.1:80 firstname.lastname@example.org
- Unfortunately, when this command runs successfully, there is no text shown..
- In a web browser, go to http://127.0.0.1:8888/phpmyadmin/
- The default credentials for a Bitnami stack are “root” and a password of “bitnami”
When you are done, you can just kill your SSH connection with a Control-C.