TABLE OF CONTENT
1. Introduction to AWS RDS2. This setup is necessary. Advantages of PHPMyAdmin4. Prerequisites5. Architectural Flow Diagram6. Steps to set up phpMyAdmin panel in RDS Database7. Conclusion8. CloudThat9. FAQs1. Introduction to AWS RDS
Amazon Web Service offers a wide variety of goods and services that can be used by businesses of all sizes. Amazon RDS (Relational Database Service) is one of Amazon’s most recognizable and popular services. Software programmers will find it easier now that this relational service is available to set up, manage, and scale a relational data base in the Amazon Cloud. Hardware support, setup functionality and patching are all available to assist with common administrative tasks. AWS RDS allows businesses to extend storage and other computational resource with one API call.
2. Why is this setup necessary?
There are many third-party tools, such as MySQL Workbench and pgAdmin. phpMyAdmin, however, is the most popular application for managing database operations for young developers who are just starting to learn about database management. phpMyAdmin is the most popular solution available on the internet. It is simple to set up and easy to use.
It can be installed on any OS, including Ubuntu, RHEL and Amazon Linux. It is compatible with almost all OS on the market.
Let’s now discuss some of the benefits that phpMyAdmin provides.
3. Advantages of PHPMyAdmin
phpMyAdmin is compatible with any OS OS servers as long as it has a web browser
phpMyAdmin’s graphical interface makes it easy to manage all types of database operations. It is easier than the MYSQL command-line editor.
This interface allows us to execute complex queries, create and edit functions, triggers and events in phpMyAdmin.
It also allows you to export your database backup in various formats such as XML and CSV, PDF. OpenDocument Text. Excel, Word, Spreadsheet.
4. Prerequisites
Web server – Apache, Nginx, IIS
PHP
Database – MySQL, MariaDB
Web Browser
We understand phpMyAdmin and it works. Let’s say you have an RDS database containing MYSQL DB that is hosted in a private network. It cannot be publicly accessed and can only accessible by AWS EC2 on a public subnet. We want to access it and manage it in my MySQL database using phpMyAdmin via Web Browser.
5. Diagram of Architectural Flow
6. Steps to set up phpMyAdmin panel in RDS Database
Configuration of an RDS Databasea. You should create an RDS database that is not accessible to the public. Modify the security group of the RDS database. Make sure it has inbound EC2 hosting in the public subnet. Here, I have specified my security groups on EC2 hosted at a public subnet in my RDS DB security rule Inbound. The database will allow requests from any instance that uses the exact same security group.
Installing phpMyAdmin on EC2 (Ubuntu 18.04)a. SSH to your EC2b. sudo suc. apt-get updated. apt-get update -ye. apt-get install apache2 -yf. apt-get install mysql-serverg. mysql_secure_installationh. apt install PHP libapache2-mod php php-mysqlI. apt install PHPmyadmin php_mbstring php_gettext To select Apache, press SPACE, TAB, and then ENTERj. To set up phpMyAdmink, enter any password. phepenmod mbstringl. systemctl restart apache2m. Add these linesnano /etc/apache2/sites-enabled/000-default.confInclude /etc/phpmyadmin/apache.confn. service apache2 restarto. nano /etc/phpmyadmin/config.inc.phpp. Add these lines$i++;$cfg[‘Servers’][$i][‘host’] = ‘__FILL_IN_DETAILS__’;$cfg[‘Servers’][$i][‘port’] = ‘3306’;$cfg[‘Servers’][$i][‘socket’] = ”;$cfg[‘Servers’][$i][‘connect_type’] = ‘tcp’;$cfg[‘Servers’][$i][‘extension’]