How To Connect AWS RDS With PhpMyAdmin(Debian)

aws-phpmyadmin-logo

STEP 1. Updating Packages.

# apt-get update

STEP 2. Installing Web Server.

# apt-get install apache2 -y

STEP 3. Installing Mysql-Server.

# apt-get install mysql-server -y

STEP 4. Installaing php5.

# apt-get install php5-cgi -y

STEP 5. Installing PhpMyAdmin.

# apt-get install php5-cgi php5-mysql php5-mcrypt php5-intl libapache2-mod-auth-mysql php5-mysql libapache2-mod-php5 php5-common -y
# apt-get install unzip -y
# cd /var/www
# mkdir phpmyadmin
# wget https://files.phpmyadmin.net/phpMyAdmin/4.4.15.4/phpMyAdmin-4.4.15.4-all-languages.zip
# unzip phpMyAdmin-4.4.15.4-all-languages.zip
# cd phpMyAdmin-4.4.15.4-all-languages
# mv * /var/www/phpmyadmin
# cd

Note:For Check PhpMyAdmin is working Properly You Have to enter following command from your web

http://domain/phpmyadmin
or
http://ip/phpmyadmin

phpmyadmin homepage

STEP 6. Setting up PhpMyAdmin To Connect with RDS.

Note:
Copy config.smaple.inc.php to config.inc.php.

# cd /var/www/phpmyadmin

# cp config.sample.inc.php config.inc.php

STEP 7. Edit the config file.

# vim /var/www/phpmyadmin/config.inc.php
$cfg[‘Servers’][$i][‘host’] = ‘EndPoint’;
$cfg[‘Servers’][$i][‘port’] = ‘3306’;

RDS phpmyadmin conf file setting

Note: My EndPoint is ‘db-1.capoeco8uhjb.us-west-2.rds.amazonaws.com’.

STEP 8. Change Permission of Config.inc.php.

# chmod 755 /var/www/phpmyadmin/config.inc.php

STEP 9. Open PhpMyAdmin From Your Web.

http://domain/phpmyadmin
or
http://ip/phpmyadmin

Note: Use the Same Username and Password which you have Created while Creating RDS.

STEP 10. After successfull Login it will be Appear like this.

RDS phpmyadmin home page