Saturday, October 19, 2019

How To Connect AWS RDS With PhpMyAdmin(Debian)

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

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’;

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

No comments:

YouTube Channel