You must have heard or used a wonderful tool named
'phpMyAdmin'. It is written in PHP intended to
handle the administration of MySQL over the Web. 
It can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute SQL Server statements, manage keys on fields, etc... etc... 
Here are the simplest steps to get it installed on a plain Linux
VPS Hosting or Dedicated server :
1. Download the latest version of phpMyAdmin from
www.phpmyadmin.net or from
here :
root@support [~]# wget http://nchc.dl.sourceforge.net/sourc...-8-only.tar.gz
2. Rename the TAR file for your convenience :
root@support [~]# mv phpMyAdmin* phpMyAdmin.tar.gz
3. Untar the package :
root@support [~]# tar xzf phpMyAdmin*
4. Move it to the appropriate place :
root@support [~]# mv phpMyAdmin /usr/share/
5. 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
6. Locate the following lines within that file & make sure each they look like the below ones :
PHP Code:
$cfg['Servers'][$i]['auth_type'] = 'http';
$cfg['Servers'][$i]['controluser'] = 'root';
$cfg['Servers'][$i]['controlpass'] = 'mysql-root-pass';
7. Save the file.
8. Create the apache configuration file for phpMyAdmin :
root@support [/usr/share/phpmyadmin]# echo "alias /phpmyadmin /usr/share/phpMyAdmin" > /etc/httpd/conf.d/phpMyAdmin.conf
9. Restart the http service :
root@support [~]# service httpd restart
10. You're done
Now, access phpMyAdmin through the following using the root login details:
http://server-ip/phpmyadmin eg:
http://10.10.10.1/phpmyadmin
