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 phpMyAdmin or from here :
root@support [~]# wget http://jaist.dl.sourceforge.net/sour...english.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

