Connect AWS RDS MySQL instance with phpMyAdmin

Step 1 : Get the latest version of phpMyAdmin from https://www.phpmyadmin.net/downloads/

Step 2 : Wget the file in your work directory

cd /var/www/html/   #move to work directory
wget https://files.phpmyadmin.net/phpMyAdmin/5.1.0/phpMyAdmin-5.1.0-english.tar.gz   #Downlaod the version in ur server
unzip phpMyAdmin-5.1.0-english.tar.gz #unzip the downloaded version
mv phpMyAdmin-5.1.0-english phpmyadmin #Rename properly for easy access
cd phpmyadmin #goto the new folder
mv config.sample.inc.php config.inc.php #move the config file to take effect

Step 3 : Changing config to access RDS

vim config.inc.php
/* RDS parameters */
$i++;
$cfg['Servers'][$i]['host'] = 'RDS Hostname';
$cfg['Servers'][$i]['port'] = '3306';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'cookie';

Step 4 : Restart apache2

sudo service apache2 restart

Access phpMyAdmin from your local browser. Enter http://SERVER_IP/phpMyAdmin enter username and password of your RDS. and access it.