How To Use PHPMyAdmin via SSH Terminal on MAC for AWS LightSail

PHPMYADMIN
Open Terminal and cd (change directory) into the folder holding your .pem file first.

Then run the following code (replace the name of key-file.pem and the ip address of the server to correctly match your case before running:

ssh -i /your-key-file.pem -L 8888:127.0.0.1:80 [email protected]

If the bitnami splash loads without errors:

Visit the following URL in your browser once you have made a proper connection:

http://127.0.0.1:8888/phpmyadmin

You will then have to login to PHPMyAdmin.

The bitnami default credentials are normally ‘root’ for username and you should be able to pull the password by running this command:

sudo cat /home/bitnami/bitnami_credentials

I hope that helps! Cheers.

– NR

Leave a Comment