PhpMyAdmin Installation Process On Linux server

By | April 17, 2012

phpMyAdmin iis a software tool written in PHP. It is an open source software to take care of the of the MySQL administration over the World Wide Web. Users can install phpmyadmin very smoothly with Linux VPS hosting or Dedicated hosting. You can follow the following link to install it :
http://www.phpmyadmin.net/home_page/downloads.php
OR
http://sourceforge.net/projects/phpmyadmin/files/

* Rename the TAR file for your convenience :
[email protected] [~]# mv phpMyAdmin* phpMyAdmin.tar.gz

* Untar the package :
[email protected] [~]# tar xzf phpMyAdmin

* Move it to the appropriate place :
[email protected] [~]# mv phpMyAdmin /usr/share/

* Configure phpMyAdmin :
[email protected] [~]# cd /usr/share/phpMyAdmin
[email protected] [/usr/share/phpmyadmin]# cp config.*.php config.inc.php
[email protected] [/usr/share/phpmyadmin]# vi config.inc.php

* Locate the following lines within that file & make sure each they look like the below ones :
$cfg[‘Servers’][$i][‘auth_type’] = ‘http’;
$cfg[‘Servers’][$i][‘controluser’] = ‘root’;
$cfg[‘Servers’][$i][‘controlpass’] = ‘mysql-root-pass’;

* Save the file.

* Create the apache configuration file for phpMyAdmin :
[email protected] [/usr/share/phpmyadmin]# echo “alias /phpmyadmin /usr/share/phpMyAdmin” > /etc/httpd/conf.d/httpd.conf

* Restart the http service :
[email protected] [~]# service httpd restart