phpMyAdmin iis a software tool written in PHP. It is an open-source software to take care 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 :
root@support [~]# mv phpMyAdmin* phpMyAdmin.tar.gz

* Untar the package :
root@support [~]# tar xzf phpMyAdmin

* Move it to the appropriate place :
root@support [~]# mv phpMyAdmin /usr/share/

* Configure phpMyAdmin :
root@support [~]# cd /usr/share/phpMyAdmin
root@support [/usr/share/phpmyadmin]# cp config.*.php config.inc.php
root@support [/usr/share/phpmyadmin]# vi config.inc.php

* Locate the following lines within that file & make sure each 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 :
root@support [/usr/share/phpmyadmin]# echo “alias /phpmyadmin /usr/share/phpMyAdmin” > /etc/httpd/conf.d/httpd.conf

* Restart the http service :
root@support [~]# service httpd restart

Popular Posts You May Read

Explore more hosting insights, tips and industry updates.

How to Check Python Version in Linux & Windows

Python is a versatile programming language, popular among developers, data scientists, and researchers. Its simplicity…

How-To-Clear-The-DNS-Cache-In-Windows-8-and-10

How To Clear The DNS Cache In Windows 8 and 10

This post guides how to clear the DNS Cache in Windows 8 and 10. By…

How to Install Kiss My Firewall?

> Log in as root.>Type cd/usr/bin>Download and extract firewall (tar zxvf kiss-2.0.1.tar.gz)>If you need to…