Hello again..

Yesterday we already learn how to install PHP and mySQL on CentOS 5, now we will learn about how to install phpMyAdmin on CentOS 5, for your information who don’t know what is phpMyAdmin, let me explain in short text, phpMyAdmin is a script written in PHP language, the function of phpMyAdmin is to handle the administration of MySQL via website. phpMyAdmin supports lot of operations with MySQL like managing databases, tables, fields, relations, indexes, users, permissions, etc and not only that, phpMyAdmin also have the ability to directly execute any SQL statement.

Ok dont wasting time anymore, lets try it..

First you must know what type is your CentOS, is it x86 (i386) or x64 (x86_64), and to find out just type

uname -i

After you find out what version is your CentOS, now its time to download the repo

for x86 (i386)

wget http://packages.sw.be/rpmforge-release/rpmforge-release-0.5.1-1.el5.rf.i386.rpm
rpm -Uvh rpmforge-release-0.5.1-1.el5.rf.i386.rpm

for x64 (x86_64)

wget http://packages.sw.be/rpmforge-release/rpmforge-release-0.5.1-1.el5.rf.x86_64.rpm
rpm -Uvh rpmforge-release-0.5.1-1.el5.rf.x86_64.rpm

Starting install phpMyAdmin

yum -y install phpmyadmin

edit file phpmyadmin.conf

vi /etc/httpd/conf.d/phpmyadmin.conf

Comment (add # mark on the front of text) the other settings and leave only the following:

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

Save (on keyboard press key “Esc” and then type “:wq”)

edit file config.inc.php

vi /usr/share/phpmyadmin/config.inc.php

Find the following line

$cfg['Servers'][$i]['auth_type'] = 'cookie';

And replace ‘cookie‘ with ‘http‘

Restart Apache

service httpd restart

DONE !!
To login just type http://yoursite.com/phpmyadmin and login with ur root and mysql password

Enjoy