Amazon Web Service currently offers one-year-free trial of their services and I am experimenting with their database service. I set up a MySQL server database. However, after the service was ready, I found out that, AWS doesn”t provide GUI to access the database. I always use phpMyAdmin to manage MySQL database because it is easy and thinking whether I could use phpMyAdmin to manage my AWS database or not. After a quick research on the Internet, I found out that it is possible. How could we do that?
First, we need to install phpMyAdmin. The good thing about phpMyAdmin is it is a web application, doesn”t matter the type of Operating System you have as long as it has web server to host phpMyAdmin you are set. Second you need to modify phpMyAdmin configuration file by adding few lines on it. The file that you need to modify is config.inc.php. Different OS has different location for this file. I used Ubuntu 14.04 and Windows 7 XAMPP.
- Ubuntu 14.04 –> /etc/phpmyadmin
- Windows 7 XAMPP –> \xampp\phpMyAdmin (relative to your xampp root document by default it is in C:)
Add these following lines inside the php tag of config.inc.php