Install & Configure Apache, PHP, JSP, Ruby on Rails, MySQL, PHPMyAdmin & WordPress on Windows XP/2000
On the PHPMyAdmin download page, click the zip link for version 2.7.0-pl2. Choose a sourceforge mirror to begin downloading.
File Name: phpMyAdmin-2.7.0-pl2.zip
Download Location: http://phpmyadmin.net/
- Extract phpMyAdmin-2.7.0-pl2.zip to your DocumentRoot directory. Rename the folder to "phpmyadmin".
Note: The default DocumentRoot directory for Apache is the following directory:
C:\Program Files\Apache Group\Apache2\htdocs.
- Create a copy of config.default.php and rename it to config.inc.php.
- Open the config.inc.php from the phpmyadmin directory in your favorite text editor and modify the following lines.
$cfg['PmaAbsoluteUri'] = 'http://localhost/phpmyadmin/';Note: If you want PHPMyAdmin to work from a machine other than itself, put in the real domain name or IP address instead of "localhost".
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'http';
- Open php.ini from C:\php and add make the following changes
Uncomment line 627
A add a new line 648extension=php_mysqli.dll
Edit Line 778mysqli.default_host = localhost
Edit Line 781mysqli.default_user = root
- Restart your computer. This fixes a weird error with loading mysqli.dll.
- Restart Apache.
- Open http://localhost/ in a web browser. If you see something like the following, Apache restarted successfully.
Note: If you get a warning that it cannot load php_mysqli.dll, try rebooting. I believe this problem is caused by the MySQL installer altering the PATH Environment Variable without refreshing it in the registry.
If rebooting doesn't work, try copying libmySQL.dll from C:\Program Files\MySQL\MySQL Server 5.0\bin to C:\WINDOWS\System32.
- Open http://localhost/phpinfo.php in a web browser. If you see something like the following, PHP loaded successfully. If you scroll down, you should see settings for mbstring and mysqli listed.
- Open http://localhost/phpmyadmin/ in a web browser. If you see something like the following, the install was successful!
Note: Use "root" and your mysql password (from the MySQL installation) to login.