Installing phpMyAdmin integrating with Apache on CentOS 7 / RHEL 7

For phpMyAdmin is available with EPEL. we can install with EPEL repository rpm, run given below rpm to download

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

#yum install -y –enablerepo=remi-php73 phpmyadmin

  1. For phpMyAdmin, we need to places the configuration files in /etc/httpd/conf.d directory.
  2. if need to access phpMyadmin from external machines, we have to edit given below phpMyAdmin.conf file.

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

Default config will look like below.
# phpMyAdmin - Web based MySQL browser written in php
#
# Allows only localhost by default
#
# But allowing phpMyAdmin to anyone other than localhost should be considered
# dangerous unless properly secured by SSL

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>

You can comment it out the Require ip 127.0.0.1 and Require ip ::1 then add Require all granted just below to commented line.