phpMyadmin Installation on CentOS 7

Install and Configure phpMyAdmin on CentOS 7

phpMyAdmin is an open-source tool used for the administration of MySQL. We are here with very simple steps for the phpmyadmin installation.

For phpMyadmin Installation, follow these very simple steps:

Prerequisite :

• LAMP should be installed
  • Install LAMP
  • Mysql Installation
  • port allowed for GUI Access
    • iptables -I INPUT 5 -i eth0 -p tcp –dport 80 -m state –state NEW,ESTABLISHED -j ACCEPT
    • service iptables stop
    • service iptables start

Once the above prerequisite is done, please refer below steps:

Step 1: Add the EPEL Repository

rpm -iUvh http://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm

Step 2: Install phpMyAdmin

yum -y update

yum -y install phpmyadmin

Step 3: Find Your IP Address / configure the config file

cp /etc/httpd/conf.d/phpMyAdmin.conf vim /etc/httpd/conf.d/phpMyAdmin.conf_orig

step 4:

vim /etc/httpd/conf.d/phpMyAdmin.conf

replace :

<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
Allow from all
#Deny from None
# Allow from 127.0.0.1
#Allow from ::1
</IfModule>
</Directory>

or similar content with :

<Directory /usr/share/phpMyAdmin/>
Options Indexes FollowSymLinks MultiViews
AllowOverride all
Order allow,deny
Allow from All
</Directory>

Step 5: Restart the httpd server

sudo service httpd restart