How to Install phpMyAdmin 4.6 on CentOS/RHEL 7/6 & Fedora 23

Step 1: Enable Remi Repository

phpMyAdmin most updated package is available under remi repository. Install it in your system using following commands.

CentOS/RHEL 7:
# rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-7.rpm

CentOS/RHEL 6:
# rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm

CentOS/RHEL 5:
# rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-5.rpm

Fedora 20:
# rpm -Uvh http://rpms.famillecollet.com/remi-release-20.rpm

Fedora 19:
# rpm -Uvh http://rpms.famillecollet.com/remi-release-19.rpm

Fedora 18:
# rpm -Uvh http://rpms.famillecollet.com/remi-release-18.rpm

Step 2: Install phpMyAdmin

After adding remi repository, install phpMyAdmin using yum package manager.

All the dependencies will automatically be installed.

# yum --enablerepo=remi install phpMyAdmin
Step 3: Configure phpMyAdmin

phpMyAdmin by default allowed to access from localhost only. If you want to make it accessible from remote computers edit /etc/httpd/conf.d/phpMyAdmin.conf and update all 127.0.0.1 with your network like below or enable phpMyAdmin access for everyone.

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

## Comment below section to allow everyone
<Directory /usr/share/phpMyAdmin/>
    <IfModule !mod_authz_core.c>
     Order Deny,Allow
     Deny from All
     Allow from 192.168.1.0/24
     Allow from ::1
   </IfModule>
</Directory>

<Directory /usr/share/phpMyAdmin/libraries/>
    Order Deny,Allow
    Deny from All
    Allow from None
</Directory>

<Directory /usr/share/phpMyAdmin/setup/lib/>
    Order Deny,Allow
    Deny from All
    Allow from None
</Directory>

<Directory /usr/share/phpMyAdmin/setup/frames/>
    Order Deny,Allow
    Deny from All
    Allow from None
</Directory>

After updating phpMyAdmin Apache configuration file, restart Apache service to reload new settings.

# service httpd restart
Step 4: Access phpMyAdmin in Browser

Now you can access phpMyAdmin in browser using following url. Change test.zetservers.com  with your server IP.

http://test.zetservers.com/phpMyAdmin/

Login Details: Use MySQL username and password.

Congratulation’s You have successfully installed phpMyAdmin. Using single phpMyAdmin we can manage multiple MySQL servers by adding multiple remote MySQL server.

LEAVE A COMMENT