Installing phpMyAdmin

Install phpMyAdmin

1. Install the required dependency

   sudo dnf install php-mbstring php-xml -y
   

   

2. Restart Apache

   sudo systemctl restart httpd
   

3. Restart php-fpm.

   sudo systemctl restart php-fpm
   

   

4. Navigate to the Apache document root at /var/www/html.

   cd /var/www/html
   

5. Download phpMyAdmin

   wget https://www.phpmyadmin.net/downloads/phpMyAdmin-latest-all-languages.tar.gz
   

   

6. Create a folder phpMyAdmin and extract it with the following command.

   mkdir phpMyAdmin && tar -xvzf phpMyAdmin-latest-all-languages.tar.gz -C phpMyAdmin --strip-components 1
   

   

7. Remove phpMyAdmin-latest-all-languages.tar.gz tarball.

   rm phpMyAdmin-latest-all-languages.tar.gz
   

   

8. If the MySQL server is not running, start it

   sudo systemctl start mariadb
   

   

9. In the EC2 interface

   • Select Instances
   • Select Linux-instance
   • Copy Public IPv4 DNS

10. Paste Public IPv4 DNS into the browser with the following URL:

http://my.public.dns.amazonaws.com/phpMyAdmin

• You will see the phpMyAdmin login page.
• Proceed to login with user name: root and password: 123Admin
• Select Login

11. In the phpMyAdmin interface

• Create a new database by selecting New

12. Database Configuration

• Enter database name as awsuser
• Then select Create

13. Finish creating a database

14. Perform step SQL Schema to create a table user to manage user information for the database. Execute the following SQL query:

CREATE TABLE `awsuser`.`user` ( `id` INT NOT NULL AUTO_INCREMENT , `first_name` VARCHAR(45) NOT NULL , `last_name` VARCHAR(45) NOT NULL , `email` VARCHAR(45) NOT NULL , `phone ` VARCHAR(45) NOT NULL , `comments` TEXT NOT NULL , `status` VARCHAR(10) NOT NULL DEFAULT 'active' , PRIMARY KEY (`id`)) ENGINE = InnoDB;

• Select awsuser database just created
• Select SQL
• Paste the code SQL query in
• Select Format to customize the format of SQL
• Then select Go

15. Complete database creation and create tables in the database.