How To Connect AWS RDS With PhpMyAdmin

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


Unzip the phpMyAdmin package by using below commands


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

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.


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

Place the phpMyAdmin in desired location for ex:


Add the below lines in Apache VirtualHost.

Alias /phpMyAdmin/ "/var/www/phpMyAdmin/"
<Directory "/var/www/phpMyAdmin">
    AllowOverride All 
    Require all granted
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.
100% LikesVS
0% Dislikes

One Comments

  • Heya i am for the first time here. I found this board and I find It really useful & it helped me
    out a lot. I hope to give something back and aid others like you helped me.

Comments are closed.