Installing phpMyAdmin on CentOS 5.6

Install MySQL packages
# yum install mysql-server mysql mysql-devel

Make MySQL boot up automatically
# chkconfig mysqld on

Start MySQL service
# service mysqld start

Set the password for the root user
# mysqladmin -u root password kezhong

Install php and common packages
# yum install php php-gd php-imap php-mysql php-pear php-xml phpxmlrpc curl libxml2 php-mbstring php-mcrypt

Install phpMyAdmin
Because the version of php on CentOS 5.6 is 5.1.6, we only can install phpMyAdmin 2.x, I choose 2.11.11.3.
# cd /usr/share
# wget http://sourceforge.net/projects/phpmyadmin/files/phpMyAdmin/2.11.11.3/phpMyAdmin-2.11.11.3-english.tar.gz/download
# tar xvfz phpMyAdmin-2.11.11.3-english.tar.gz
# mv phpMyAdmin-2.11.11.3-english phpmyadmin
# rm phpMyAdmin-2.11.11.3-english.tar.gz
# cd phpmyadmin
# cp config.sample.inc.php config.inc.php

Edit the config.inc.php file, find the line that contain “blowfish_secret”, and modify like below.
$cfg['blowfish_secret'] = ‘TypeAnything_for_Secure’;

Append a line into the /etc/httpd/conf.d/phpmyadmin.conf file
# echo “Alias /phpMyAdmin /usr/share/phpmyadmin” >> /etc/httpd/conf.d/phpmyadmin.conf

Restart the httpd service
# service httpd restart

Enter the URL http://[IP Address]/phpMyAdmin/ on Firefox browser, we’ll can see the login web page.