INSTALLATION OF PHPMYADMIN ON CENTOS 7
PHPMYADMIN is a Web-based administration tool for Managing MYSQL, MariaDB database servers.It helps us to perform activities like creating, deleting, querying, tables, columns, Import and export the databases, permissions, users etc.
This tutorial helps you to install PhpMyAdmin on Centos 7.
Before Installing phpMyAdmin, You must have the LAMP server installed on your server.
Here is the tutorial on Installing LAMP server on Centos 7.
You can download and install epel repository using the below command:
#rpm -Uvh https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm
Install PhpMyAdmin using the command:
#yum install phpmyadmin -y
Configuration of Phpmyadmin
PhpMyAdmin stores the configuration file under /etc/httpd/conf.d/ directory Which has rules and permissions for access.
By default, Only the Localhost is allowed to access the PHPMyAdmin Web interface.
To change that, We need to edit the configuration file of phpmyadmin.
The default configuration looks like this
Comment out Require ip 127.0.0.1 and Require ip ::1 and then add Require all granted just below to the commented line, As shown below
Restart the services:
#systemctl restart httpd
If you failed to allow the web server to an external network, You have to allow using the below command:
#firewall-cmd –permanent –zone=public –add-port=80/tcp
You can access the PHPMyAdmin web interface from the Browser, URL will be
You will see the following screen.
You can log in using root (DB admin) or any database user provided the password.
You will get the Database page.
Now, You can manage your database, users etc using this web interface.
That’s All.Hope this helped you.Thanks for reading this article.