Access phpMyAdmin for EC2 Instances running Bitnami WordPress Certified AMI
< Back to Blog1. Connect to EC2 instace via SSH
Follow this guide. Once connected, execute this command to obtain the password for logging into phpMyAdmin (must be in the /home/bitnami/ folder):
cat ./bitnami_credentials
Copy the pass phrase that the terminal kicks out, and save it for later use. You can now exit the server with “exit”. This should return you to your local file structure.
2. Create secure tunnel
On your local machine, in your terminal, run the following command, but replace SERVER-IP with the public IP address and KEYFILE with the path to your private key:
ssh -N -L 8888:127.0.0.1:443 -i KEYFILE bitnami@SERVER-IP
If the command was executed correctly, the terminal will create an SSH tunnel and will not display any output on the server console.
3. Access phpMyAdmin
Access the phpMyAdmin console through the secure SSH tunnel you created, by browsing to: https://localhost:8888/phpmyadmin/
- Log in with these credentials:
- User: root
- Password: The copied pass phrase from step 1