How to access phpmyadmin using putty for wordpress lightsail

access phpmyadmin in lightsail

If you are new on amazon lightsail its difficult for you to access your AWS lightsail PHPMyAdmin because you can’t access your database directly from URL i.e www.yourDomainName.com/phpmyadmin.

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 appear, 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 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 ask 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
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. Web design and development constantly developing every day with new trends, ideas, and innovations. That’s why nowadays you need to learn and keep yourself up-to-date with everything daily and that’s what I do and that is something that I love because I am so passionate about it! When I have spare time I use to give time to my web development community. Teaching kids, managing online programming groups, attending a conference and making blogs, I like keeping myself up-to-date and engaged in my field always. I have my expertise in (PHP, Codeigniter, Laravel, Bootstrap, WordPress, SQL, Query Optimization, Data Science and Design Patterns). Anyone who wants to learn and know anything about web development and design I am always available for that and would love to help out. I always love to be looking out for new things and that is why I spend a lot of my time learning new techniques and helping other people learn web development and design through various groups and web development tutorials as well as online courses.

Leave a Reply

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

WhatsApp chat