phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields, manage privileges, export data into various formats and is available in 50 languages.http://wiki.cihar.com/pma/phpMyAdmin
DocumentRootand unzip the downloaded file into it.
config.sample.inc.phpand rename it to
config.inc.phpfile with a text editor and search for the
blowfish_secretconfiguration. Define a secret value to be used when encrypting the password in cookies (e.g.
$cfg['blowfish_secret'] = 'cookie based authentication encryption phrase';).
Open your browser and head to http://localhost/phpMyAdmin/.
Enter your MySQL username and password to login.
When authenticated you should see two warnings:
You need to enable these extensions in your PHP configuration file.
php.ini file in a text editor and search for
;extension=php_mcrypt.dll and remove the
; character in front of them.
Restart Apache so these extensions can be loaded.