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