How to access phpmyadmin using putty for wordpress lightsail

access phpmyadmin in lightsail

If you are new on amazon lightsail, it’s difficult for you to access your AWS lightsail PHPMyAdmin because you can’t access your database directly from URL, i.e.,

So before accessing your phpMyAdmin via SSH tunnel, what you need SSH client PuTTY is free for Windows and UNIX platforms. So download the putty.exe and also the puttygen.exe from the official website.

download the putty.exe for SSH
download the puttygen.exe for key generation utility

Step1: Now you need the SSH Access before downloading it go to the lightsail and select your instance then click on the options button and select Manage option

connect instance on lightsail

Now find the account page link and click on it. A new page appears.

find account page on lightsail

Now download the key and keep that key in a folder where you keep the putty.exe and puttygen.exe file.

download the SSH key on lightsail

Step:2 Open the puttygen.exe and load your key by clicking on the load button it will not show you the .pem file, change the file types all files now it will show you the .pem file, a popup appears, click ok and then click on the Save private key button, give you key name, i.e., myKey and keep it on the same folder, it’s a .ppk file.

generate ppk file using puttygen

Step3: Now click on the putty, you need the IP of your instance, i.e., get your IP from amazon lightsail, Add your IP in the Host Name field and also in the session field.

add ip in putty

Step4: Now open the SSH and click on the Auth and click on the browse button, choose your .ppk file

select your ppk file

Step5: Click on the Tunnels add 8888 in the source port and localhost:80 in Destination, and don’t forget to click on the add button.

adding the tunnels in putty for lightsail

Step6: Now, click on the Data and add the user bitnami in the Auto-login username.

adding bitnami as user in putty

Step7: Click on the Session and click on the open button. Note: if you have a default session, please select the Session which you have inserted.

click session and open

Step8: Now, a window appears like this.

showing bitnami console in putty

If putty asks you about cached, this key just click on the yes button.

cach the key

Step9: Go to the browser and type localhost:8888/phpmyadmin. It will ask you about credentials to access the database using the root as username, and if you have the password, then add it otherwise get your password by access SSH on lightsail.

open phpmyadmin
use the credentials for phpmyadmin in lightsail suing putty

Congratulation, you have successfully accessed your lightsail PHPMyAdmin panel using putty.

php logged in using lightsail

Learn How To Use AWS Lightsail Hosting For WordPress

My Name is Shehzad Ahmed and I am a full-time developer with over 7+ years of experience. In that time, I’ve worked as a developer with many big and small firms and was teaching web design and development skills to many keen learners and by the time passes I’ve found a great passion and potential on myself as a teacher on this particular field and now I am a full-time teacher and working as a freelancer.

Leave a Reply

Your email address will not be published. Required fields are marked *

Featured Courses

Learn Web Development and web designing in few months from shakzee with real-world experience. Get up to 80% discount!