Configure phpMyAdmin

Installation

Fetch the latest stable tarball from www.phpmyadmin.net and untar it to /var/www/html/somedir,

tar xzf phpmyadmin-xxx.tar.gz

mv phpmyadmin-xxx /var/www/html/somedir

Make sure apache is started,

ps aux | grep httpd

#service httpd status or apachectl status

Point your desktop's web browser MySQL's server IP or name,

MYSQL_SERVER/

Click on setup script > new server > just fill the password line

Display the configuration and Copy/Paste it

Back to the server, paste the configuration to a new file inside the somedir/ directory,

cd /var/www/html/myadmin

vi config.inc.php #(Paste the configuration, write and exit)

To secure the web interface use Apache's "Basic authentication". See pbraun.nethence.com/doc/www/apache.html

Or use one of the other authentication capabilities, like,

$cfg['Servers'][$i]['auth_type'] = 'cookie';

Fix users & privileges

See the "Databases" and "Privileges" tabs. Make sure each user has only grant access to its own database.

Also eventually remove the second root user, the local one is enought.

UNIX / Configure phpMyAdmin