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.
Dana
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.