Simple steps to install phpMyAdmin on centos 6.3

First, we make our CentOS system's RPMForge software repository phpMyAdmin, which is not the official CentOS 6.0 repository, import rpmforge's GPG key:

rpm –import http://dag.wieers.com/rpm/packages/RPM-GPG-KEY.dag.txt

x86_64 System installation command:

yum install http://pkgs.repoforge.org/rpmforge-release/rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm

i386 System installation command:

yum install http://pkgs.repoforge.org/rpmforge-release/rpmforge-release-0.5.2-2.el6.rf.i686.rpm

Now you can Install phpMyAdmin as follows:

yum install phpmyadmin
Now, we configure phpMyAdmin. Change the configuration of Apache so that phpMyAdmin connects and comment out lines 3-8:

vi /etc/httpd/conf.d/phpmyadmin.conf
#
# Web application to manage MySQL#
#
# Order Deny,Allow
# Deny from all
# Allow from 127.0.0.1
#
Alias /phpmyadmin /usr/share/phpmyadmin
Alias /phpMyAdmin /usr/share/phpmyadmin
Alias /mysqladmin /usr/share/phpmyadmin

Next, we change the authentication in phpMyAdmin and change 'cookie' to 'HTTP':

vi /usr/share/phpmyadmin/config.inc.php
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'http';

Restart Apache:

/etc/init.d/httpd restart

After that, you can manage the database by visiting phpMyAdmin http://42.168.0.100/phpmyadmin/.