Install phpMyAdmin

Table of contents

Introduction

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

Download & Unpack

  1. Download the appropriate distribution kit from the official phpmyadmin.net downloads page.
  2. Create a folder inside your DocumentRoot and unzip the downloaded file into it.
  3. Rename the unzipped directory to phpMyAdmin (e.g. C:\public_html\phpMyAdmin).

Configuration

  1. Go to your phpMyAdmin folder. Copy the file config.sample.inc.php and rename it to config.inc.php.
  2. Edit config.inc.php file with a text editor and search for the blowfish_secret configuration. Define a secret value to be used when encrypting the password in cookies (e.g. $cfg['blowfish_secret'] = 'cookie based authentication encryption phrase';).

Testing phpMyAdmin

Open your browser and head to http://localhost/phpMyAdmin/.
Enter your MySQL username and password to login.

When authenticated you should see two warnings:

The mbstring PHP extension was not found and you seem to be using a multibyte charset. Without the mbstring extension phpMyAdmin is unable to split strings correctly and it may result in unexpected results.

Cannot load mcrypt extension. Please check your PHP configuration.

You need to enable these extensions in your PHP configuration file.
Open your php.ini file in a text editor and search for ;extension=php_mbstring.dll and ;extension=php_mcrypt.dll and remove the ; character in front of them.

Restart Apache so these extensions can be loaded.