How to install phpMyAdmin [PMA] on a Linux VPS/Dedicated server !

[Rock]

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 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

------------------------

For Steps to install it on Windows check the link below:

Install PHPMyAdmin On Windows

[mephisto]

Personally I don't use phpMyAdmin for my admin work. If I need to view my databases in a gui I don't like putting the root password into a file. Of course I can install for a single user for a single database, but I hardly ever have the need to.

If you have a VPS Hosting/Dedicated then you can ssh, so it would be much better to create a ssh tunnel to the VPS Hosting to mysql, assuming of course you've secured MySQL Server not to listen on an external IP address.

ssh user@host -L 3306:localhost:3306

...or if you have windows client, follow this web site hosting for using putty...

Real Programmers: How To: Set Up An Ssh Tunnel With Putty -- by hackers, for hackers

Then you can use these lovely tools provided by Mysql, when you put in your connection details use localhost as your server details rather than your VPS Hosting IP address, because it's going to go over a ssh tunnel.

MySQL :: MySQL GUI Tools Downloads

[vzAddict]

Hello,

Great tutorial Rocky... you really Rock