How To Install phpMyAdmin on CentOS 7 / RHEL 7

phpMyAdmin is the web-based administration tool for managing the MySQL, MariaDB and Drizzle servers. It helps in performing databases activities such as creating, deleting, querying, tables, columns, relations, indexes, users, permissions, etc.

This guide will help you to install phpMyAdmin on CentOS 7 / RHEL 7.

Before installing phpMyAdmin, you must have LAMP Stack installed on the server.

Install phpMyAdmin on CentOS 7

phpMyAdmin is available in EPEL, so Install EPEL repository rpm.

rpm -Uvh https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm

Install phpMyAdmin using the following command.

yum -y install phpmyadmin

Configure phpMyAdmin

phpMyAdmin places the configuration files in /etc/httpd/conf.d directory. It has rules and permission for the access.

By default, phpMyAdmin can be accessed only from the localhost, to change that; we have to edit the phpMyAdmin.conf file.

In CentOS 7, web access is managed by the mod_authz_core.c module; so normal allow or deny rules won’t work even if you modify.

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

Default config will look like below.

Alias /phpMyAdmin /usr/share/phpMyAdmin
Alias /phpmyadmin /usr/share/phpMyAdmin

<Directory /usr/share/phpMyAdmin/>
   AddDefaultCharset UTF-8

   <IfModule mod_authz_core.c>
     # Apache 2.4
     <RequireAny>
       Require ip 127.0.0.1
       Require ip ::1
     </RequireAny>
   </IfModule>
   <IfModule !mod_authz_core.c>
     # Apache 2.2
     Order Deny,Allow
     Deny from All
     Allow from 127.0.0.1
     Allow from ::1
   </IfModule>
</Directory>

<Directory /usr/share/phpMyAdmin/setup/>
   <IfModule mod_authz_core.c>
     # Apache 2.4
     <RequireAny>
       Require ip 127.0.0.1
       Require ip ::1
     </RequireAny>
   </IfModule>
   <IfModule !mod_authz_core.c>
     # Apache 2.2
     Order Deny,Allow
     Deny from All
     Allow from 127.0.0.1
     Allow from ::1
   </IfModule>
</Directory>   

Please comment out Require ip 127.0.0.1 and Require ip ::1 then add Require all granted just below to commented line, it will look like below.

Alias /phpMyAdmin /usr/share/phpMyAdmin
Alias /phpmyadmin /usr/share/phpMyAdmin

<Directory /usr/share/phpMyAdmin/>
   AddDefaultCharset UTF-8

   <IfModule mod_authz_core.c>
     # Apache 2.4
     <RequireAny>
       #Require ip 127.0.0.1
       #Require ip ::1
       Require all granted
     </RequireAny>
   </IfModule>
   <IfModule !mod_authz_core.c>
     # Apache 2.2
     Order Deny,Allow
     Deny from All
     Allow from 127.0.0.1
     Allow from ::1
   </IfModule>
</Directory>

<Directory /usr/share/phpMyAdmin/setup/>
   <IfModule mod_authz_core.c>
     # Apache 2.4
     <RequireAny>
       #Require ip 127.0.0.1
       #Require ip ::1
       Require all granted
     </RequireAny>
   </IfModule>
   <IfModule !mod_authz_core.c>
     # Apache 2.2
     Order Deny,Allow
     Deny from All
     Allow from 127.0.0.1
     Allow from ::1
   </IfModule>
</Directory>

Restart the services.

systemctl restart httpd

Configure the firewall to allow HTTP requests from external networks.

firewall-cmd --permanent --add-service=http
firewall-cmd --reload

Access phpMyAdmin

Now access the phpMyAdmin from the browser, URL will be:

OR

Login with the root (DB admin) or any database user.

You will get the database page.

That’s All.