Install phpMyAdmin on CentOs 6

Today I was trying to install phpMyAdmin on CentOs 6 and had  interesting walkthrough of the installation

1. Get the latest copy of phpMyAdmin from sourceforge

wget -c http://sourceforge.net/projects/phpmyadmin/files/phpMyAdmin/3.4.9/phpMyAdmin-3.4.9-english.tar.gz  /download

2. Extract the files

tar xvfz phpMyAdmin-3.4.9-english.tar.gz

3. move the extracted files to proper location

mv phpMyAdmin-3.4.9-english.tar.gz /var/www/html/phpmyadmin

4. cd /var/www/html/phpmyadmin

5. Make a copy of configuration files

cp config.sample.inc.php config.inc.php

6. Modify the values vi config.inc.php

$cfg['Servers'][$i]['auth_type']=’cookie’; to $cfg['Servers'][$i]['auth_type']=’http’;

7. Restart apache from any of command

service httpd restart – Work for me
/etc/init.d/httpd restart

8. Open browser on server

http://localhost/phpMyAdmin

You may end in following errors

1. 404 Not Found Error
Please make sure you push your phpMyAdmin directory in your webroot. In my case it’s /var/www/html

2. 403 Forbidden Error
I spend good amount of time finding why access is forbidden and finally did following setting

2.1 Go to /etc/httpd/conf.d/

2.2 vi phpMyAdmin.conf

2.3 Add following lines

<Directory /var/www/html/phpMyadmin>
Order allow, deny
Options Indexes
Allow from all
</Directory>

Still not able to access, try disabling the SElinux

SElinux is extra security layer in Linux and sometimes it provide conflicts for apache to work

• vi /etc/selinux/config
• Modify SELINUX=enforcing  to SELINUX=disabled  //Discuss with your senior. Mine is test server.
• Restart your machine

hit http://localhost/phpMyAdmin prompt for username/password for mysql login

Please note all the steps executed via root credentials . You can use su command to login as root and carry the same steps.

I would like readers to drop the reviews comments to improve this article.

Advertisement

Tags: CentOS, Install phpMyAdmin, Linux