Faculty of Science, Engineering and Technology Swinburne University of Technology
COS80001 1
Installing phpMyAdmin on a Linux EC2 instance
PhpMyAdmin is a web-based MySQL administration tool. You can follow the following instructions
to install phpMyAdmin on a Linux EC2 instance.
1. Download phpMyAdmin onto your Linux EC2:
– SSH into your EC2 instance using Putty.
– Navigate to the Apache document root directory:
cd /var/www/html
– Download phpMyAdmin source file:
wget https://files.phpmyadmin.net/phpMyAdmin/4.8.2/phpMyAdmin-
4.8.2-english.zip
– Unzip the downloaded zip file:
unzip phpMyAdmin-4.8.2-english.zip
– Change the directory name to phpmyadmin:
mv phpMyAdmin-4.8.2-english phpmyadmin
2. Reconfigure phpMyAdmin:
– Open WinSCP and navigate to phpmyadmin directory (var/www/html/phpmyadmin)
– Change the name of config.sample.inc.php file to config.inc.php
– Open config.inc.php file and look for this line:
$cfg[‘Servers’][$i][‘host’] = ‘localhost’;
– Replace ‘localhost’ with the endpoint of your RDS instance.
$cfg[‘Servers’][$i][‘host’] = ‘your_rds_endpoint’;
3. Access phpMyAdmin from your local machine:
– From a browser on your local machine, visit
http://your-ec2-public-dns.compute.amazonaws.com/phpmyadmin/
– Enter the username and password of your DB.