How To Install and Configure phpMyAdmin in Centos6/RHEL6


Overview :

phpMyAdmin is a free and open source software written in PHP and used to handle the administration of MySQL with the use of a Web browser. It can perform various tasks such as creating, modifying or deleting databases, tables, fields or rows; executing SQL statements; or managing users and permissions

Prerequisites of phpMyAdmin :

Following following packages should be installed on linux machine in which we are going to install phpMyAdmin


To Verify the packages are installed or not :

[root@localhost ~]# rpm -qa | egrep -i "php|php-mysql|httpd|mysql-server"

if these packages are not installed  , use the below command to install

[root@localhost ~]# yum install php  php-mysql httpd mysql-server


Step:1 Create a directory using below command
[root@localhost ~]#  mkdir /download
[root@localhost ~]# cd /download


Step:2 Download the latest phpmyadmin tar file using below comand
[root@localhost download]# wget


Step:3 Extract or untar the file using below command
 root@localhost download]# tar jxpvf phpMyAdmin-3.5.6-all-languages.tar.bz2


Step:4 Move phpmyadmin folder to default document root of apache web server
[root@localhost download]# mv phpMyAdmin-3.5.6-all-languages /var/www/html/phpmyadmin


Step:5  Change the directory
[root@localhost download]# cd /var/www/html/phpmyadmin/
Step:6 copy the config file
 [root@localhost phpmyadmin]# cp


Step:7 Now edit file , change Authentication type from cookie to http
[root@localhost phpmyadmin]# vi


save & exit

Step: 8 Now start the apache and mysql service
[root@localhost phpmyadmin]# service httpd restart
[root@localhost html]# /etc/init.d/mysqld restart

Note :

1. Also Make sure selinux is disabled or else write the selinux rule, so that apache can read phpmyadmin files
2. Set the mysql root password if not set use below command :

[root@localhost ~]# mysqladmin -u root password NEWPASSWORD
Step:9 Now Access phpmyadmin from your broswer

http://localhost/phpmyadmin  or

Use root as username and password that you have set using above mysqladmin command , after entring the correct credentials  , you will get below windows where you can perform all database admin tasks.