Install phpMyAdmin on Centos 6.6

Install phpMyAdmin on Centos 6.6

My base install has selinux=disabled, iptables off, eth0 interface setup for static , ntp working, httpd installed, MariaDB (MySQL) installed, and PHP installed. All of those things have been verified as working 100%. I have how to do all those things in this blog.

login as root

Add the the repository that is for your OS. Do this in your home directory. if root then it should be /root

## RHEL/CentOS 6 64-Bit ## 
# wget http://download.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm 
# rpm -ivh epel-release-6-8.noarch.rpm

# yum -y install 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.

Like:

<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>

 Now restart httpd

 # service httpd restart

Now login into your phpMyAdmin console with your web browser with:

http://my_ip_address/phpMyAdmin

Of course that means use the IP address of the server you just installed phpMyAdmin on.

When I setup MySQL I allowed root login and gave it a password. You must use a MySQL account with a password when accessing your MySQL through phpMyAdmin.

If your still getting denied:

You need to follow the following steps: Find line that read follows Require ip 127.0.0.1 Replace with your workstation IP address: Require ip 10.1.3.53 Again find the following line: Allow from 127.0.0.1 Replace as follows: Allow from 10.1.3.53 Also find deny from all and comment it in the entire file. Save and close the file.Restart Apache httpd server

The End :)