PHPMYADMIN ON CENTOS 7

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.

https://www.linuxcloudops.com/lamp-on-centos-7/

Install Phpmyadmin

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.

#vi /etc/httpd/conf.d/phpMyAdmin.conf

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

Firewall Configuration

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

#firewall-cmd –reload

Access PhpMyAdmin

You can access the PHPMyAdmin web interface from the Browser, URL will be

http://serverIPAddress/phpMyAdmin

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.