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 directorywget https://files.phpmyadmin.net/phpMyAdmin/5.1.0/phpMyAdmin-5.1.0-english.tar.gz   #Downlaod the version in ur serverunzip phpMyAdmin-5.1.0-english.tar.gz #unzip the downloaded versionmv phpMyAdmin-5.1.0-english phpmyadmin #Rename properly for easy accesscd phpmyadmin #goto the new foldermv 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.

--

--

Chetan Bothra

Chetan Bothra

AWS Certified Solution Architect, 5+ yrs hands on exp on AWS Services. Preparing for AWS Security Speciality.