Free Software Server Environment: PHP MySQL Admin

http://www.phpmyadmin.net/∞

PHP MySQL Admin

Installation

Install the phpmyadmin CentOS, Red Hat RHEL RPM or Xubuntu DEB (using synaptic)

Configure

You can manually edit or use http://localhost/phpmyadmin/scripts/setup.php∞ to autogenerate phpmyadmin/config/config.inc.php
First goto http://localhost/phpmyadmin/scripts/setup.php∞ and enter your mysql servername, name & password
Then click Save to autogenerate phpmyadmin/config/config.inc.php

Login

Goto http://localhost/phpmyadmin/index.php∞ and choose a server

∞
you should then get a list of databases on that server

∞

Re-Configure

After running http://localhost/phpmyadmin/scripts/setup.php∞ and choosing configuration LOAD, updating your settings and configuration SAVE to update phpmyadmin/config/config.inc.php you must

# touch phpmyadmin/config.inc.php

otherwise the new config is NOT loaded into phpmyadmin because of some bizare apache/php/phpmyadmin caching !

Multiple DBs

PhpMySqlAdminMultipleDbs

Search all database tables and all columns for a value

PHPMyAdmin has a great feature that allows you to search all database tables and all columns for a value !

Run PHPMyAdmin
Choose a database
Click on the Search tab

Search in database : 
Word(s) or value(s) to search for (wildcard: "%"):

and you can choose to search any/all tables in the database

REFERRERS
MySqlAdministration
PhpMySqlAdminMultipleDbs