How You Can Connect To phpMyAdmin On Your AWS LightSail Server

Now you can open Putty application and define the connection parameters for the AWS server. 

Just make sure to use the PPK file for your private key for the connection.

STEP 1: Open a new connection and enter the IP address of the AWS Server IP Address at Session screen.

Putty New Connection Screen For AWS SSH Tunnel Creation

STEP 2: Now you need to enter the user id and private key in the Connection section.

 As we are going to create a SSH connection, we need to enter Username, Private key and Port Information in the Connection settings. All three things will go in different screens.

Click on Data tab under Connection settings and enter Username ‘bitnami’ in Auto-Login username field.

Putty Username Entry On Connection Screen

STEP 3: Now open Auth section and enter the path for the private key (PPK file).

Putty Private Key Entry On Connection Screen

STEP 4: Open Tunnels section and enter the below values for the port fields.

Source Port: 8888

Destination: localhost:80

If you have enabled the SSL by following our guide, please change the destination port from 80 to 443. 

Once done, click on add to save the port information.

Putty Port Information On Connection Screen

STEP 5: Now Go back to Session screen and enter a name for the session.

 Click on Save to save the settings, so each time you can just load the session to connect to your AWS Server.

Once done, click on connect and you will see a Bitnami welcome screen. 

If you see a popup before that, just click on Yes and it will take you to Bitnami welcome screen.

This means, you have connected to AWS Server and a tunnel has been established.

 Now go to below URL and access PHPMyAdmin.

http://127.0.0.1:8888/phpMyAdmin/

If you have SSL enabled change HTTP to HTTPS in above URL.

 https://metablogue.com/connect-phpmyadmin-aws-lightsail/