How to Install PHPMyAdmin in Apache 2.2 for Windows
18 April 2009
PHPMyAdmin is a freeware written in PHP intended to handle the administration of MySQL over the Web. With this freeware you can easily managing databases, tables, fields, relations, indexes, users, permissions, etc. This article will guide you how to install PHPMyAdmin in Apache 2.2 for Windows.
This article assumes that you already read the preceding articles:
- How to Install Apache, PHP and MySQL in Windows – Preparation
- How to Install Apache 2.2 in Windows
- How to Install MySQL 5.0 in Apache 2.2 for Windows
- How to Install PHP 5 in Apache 2.2 for Windows
Installation
- Extract file phpMyAdmin-2…-english.zip in c:\apache2\htdocs.
- Rename the created phpMyAdmin-2….-english folder to phpmyadmin. Now all of your phpmyadmin’s files should be in c:\apache2\htdocs\phpmyadmin.
- Rename config.samples.inc.php to config.inc.php
- Open config.inc.php with your text editor
- Find the line:
$cfg[‘blowfish_secret’] = ‘’;
Disable that line by inserting double slash in the beginning of that line.
// $cfg[‘blowfish_secret’] = ‘’;
- Find the authentication section.
/* Authentication type */
$cfg[‘Servers’][$i][‘auth_type’] = ‘cookie’;
Change it to:
/* Authentication type */
// $cfg[‘Servers’][$i][‘auth_type’] = ‘cookie’;
$cfg[‘Servers’][$i][‘user’] = ‘your_mysql_username’;
$cfg[‘Servers’][$i][‘password’] = ‘your_mysql_password’;
- Find the MySQL Extension section:
/* Select mysqli if your server has it */
$cfg[‘Servers’][$i][‘extension’] = ‘mysql’;
Change it to:
/* Select mysqli if your server has it */
$cfg[‘Servers’][$i][‘extension’] = ‘mysqli’;
Congratulations.
Now you can run the PHPMyAdmin from:
http://localhost:8080/phpmyadmin.