How to Install phpMyAdmin on LAMP server by Raj Gupta

phpMyAdmin is a web-based database management tool that we can use to view and edit the MySQL databases on our EC2 instance.

1. Install the required dependencies
[root@ip-172-31-95-205 ~]# sudo yum install php-mbstring -y

2. Restart Apache.

[root@ip-172-31-95-205 ~]# sudo systemctl restart httpd

3. Restart php-fpm.

[root@ip-172-31-95-205 ~]# sudo systemctl restart php-fpm

4. Now go to Apache document root at /var/www/html.

[root@ip-172-31-95-205 ~]# cd /var/www/html

5. Now download the required package from  https://www.phpmyadmin.net/downloads

[root@ip-172-31-95-205 html]# wget https://files.phpmyadmin.net/phpMyAdmin/4.8.5/phpMyAdmin-4.8.5-all-languages.zip

6. Now unzip the downloaded file

[root@ip-172-31-95-205 html]#unzip phpMyAdmin-4.8.5-all-languages.zip

[root@ip-172-31-95-205 html]# ls

phpinfo.php  phpMyAdmin-4.8.5-all-languages  phpMyAdmin-4.8.5-all-languages.zip

7. Now rename the unzip file name phpMyAdmin-4.8.5-all-languages to phpMyAdmin

[root@ip-172-31-95-205 html]# mv phpMyAdmin-4.8.5-all-languages phpMyAdmin

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

[root@ip-172-31-95-205 html]# sudo systemctl start mariadb

9. In a web browser, give the below URL

http://100.26.104.220/phpMyAdmin

you will get output like below

10. Now enter Username and password of your MySQL database then click on Go

In my case Username is root and password is raj123456

Now we get the GUI mode of our database,

We are able to perform all the action on our database by using this GUI screen.