How to install and configurePhpMyAdmin in cent os 6

PhpMyAdmin is an open source tool used for the administration of MySQL.

PhpMyAdmin provides the GUI(graphical user interface) for the ease to create , edit, delted, manage users and databases. It is also used to give permission, upload and extract the contents of databases and much more tasks.

You must have LAMP already installed in your cent os machine. You can follow the link given below to install LAMP.

Finally install PhpMyAdmin

Execute the command given below:

rpm –import
yum install
yum -y install phpmyadmin

To allow remote login to the PhpMyAdmin

vi /etc/httpd/conf.d/phpMyAdmin.conf

Replace text “Allow from” to “Allow from all”, save the file and exit. line number 25

To configure PhpMyAdmin

Edit the configuration file

vi /etc/phpMyAdmin/

Replace text:

$cfg[‘Servers’][$i][‘auth_type’] = ‘cookie’;


$cfg[‘Servers’][$i][‘auth_type’] = ‘http’;

which is the Authentication method based on cookie or http.

Once done save and exit.

Restart the apache

service httpd restart

You can verify whether or not it has been successfully installed by browsing your ip address:



it will ask for username and password which will be root and password of you mysql which we have learnt in previous article.

Rajkishor Maharjan has written 17 articles