Installing phpmyadmin on CentOS5.2

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. 

Prerequisites: 
mysql



To install phpmyadmin on your CentOS system run the following commands


#cd /var/www/html
#wget http://nchc.dl.sourceforge.net/sourceforge/phpmyadmin/phpMyAdmin-3.1.4-english.tar.gz
#tar zxvf phpMyAdmin-3.1.4-english.tar.gz
#mv phpMyAdmin-3.1.4-english.tar.gz phpmyadmin
#cd phpmyadmin
#cp config.sample.inc.php config.inc.php

Edit config.inc.php file

#vi config.inc.php

$cfg['Servers'][$i]['auth_type'] = ‘http‘; # default is cookies

Restart your apache webserver for updating the setting

#service httpd restart

For accessing phpmyadmin http://your_server_ip/phpmyadmin

Enter your mysql username and password.