Before you get started, gather the below requirement:

• Apache installed and running
• Php installed version 5.6 or above
• RDS Endpoint
• RDS MySQL Username and Password

Step 1: Verify apache is running or not by using below command

sudo systemctl status apache2

if not runnig, then start the service by using below command

sudo systemctl start apache2

Step 2: Check php version should be 5.6 or above

sudo php --version

Step 3: Install and configure phpMyAdmin

cd /var/www/html/

Download phpMyAdmin from an authorized website using wget command

wget https://files.phpmyadmin.net/phpMyAdmin/5.0.2/phpMyAdmin-5.0.2-all-languages.zip

Unzip the phpMyAdmin package by using below commands

unzip phpMyAdmin-5.0.2-all-languages.zip

Rename phpMyAdmin folder and go to that folder

mv phpMyAdmin-5.0.2-all-languages phpMyAdmin && cd phpMyAdmin

Step 4: Edit the configuration file for phpMyAdmin

mv config.sample.inc.php config.inc.php

vim config.inc.php

Below is a default file

/* Server parameters */ 

$cfg[‘Servers’][$i][‘host’] = ‘localhost’;

Now, change the Host ‘localhost; with RDS String

You can get ‘RDS MYSQL ENDPOINT’ from AWS RDS console.

/* Server parameters */

$cfg[‘Servers’][$i][‘host’] = ‘RDS MYSQL ENDPOINT’;

Save file and Close by using ESC + :wq

Step 5: Access phpMyAdmin from your local browser.

Enter url to accss for ex: http://SERVER_IP/phpMyAdmin

Use MySQL Username & Password to login to phpMyAdmin.

Optional

if you don’t want to place phpmyadmin in html directory, follow the below steps.

Place the phpMyAdmin in desired location for ex:

/var/www/phpMyAdmin

Add the below lines in Apache VirtualHost.

Alias /phpMyAdmin/ "/var/www/phpMyAdmin/"
<Directory "/var/www/phpMyAdmin">
    AllowOverride All 
    Require all granted
</Directory>

Restart the apache by below command and you are good to go!

sudo systemctl restart apache2

Using the above tutorial you can integrate Amazon RDS MySQL instance to phpMyAdmin.

Please Drop Comment if you faced any issue at any point, I will try to reply asap.