Install phpMyAdmin on Server CentOS 5.5

Install phpMyAdmin on Server CentOS 5.5

phpMyAdmin is a free software tool written in PHP intended to handle the administration of MySQL over the World Wide Web. phpMyAdmin supports a wide range of operations with MySQL. The most frequently used operations are supported by the user interface (managing databases, tables, fields, relations, indexes, users, permissions, etc), while you still have the ability to directly execute any SQL statement.

Install repository from rpmforge to server

# cd /tmp

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

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

Command to view version of CentOS is x86 (32bit) or x86_64 (64bit)

# uname -i

Install phpMyAdmin

# yum -y install phpmyadmin

edit file phpmyadmin.conf

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

delete the other settings and leave only the following:

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

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

go to http://ServerIPaddress/phpmyadmin and you'll find a page like this after login with user and password mysqladmin which was created when installing MySQL.