Install & Configure Apache, PHP, JSP, Ruby on Rails, MySQL, PHPMyAdmin & WordPress on Windows XP/2000

PHPMyAdmin

Prerequisites

On the PHPMyAdmin download page, click the zip link for version 2.7.0-pl2. Choose a sourceforge mirror to begin downloading.

Version: 2.7.0-pl2
File Name: phpMyAdmin-2.7.0-pl2.zip
Download Location: http://phpmyadmin.net/

Install

  1. 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.
    Extract to DocumentRoot
  2. Create a copy of config.default.php and rename it to config.inc.php.
  3. Open the config.inc.php from the phpmyadmin directory in your favorite text editor and modify the following lines.

    Line 31.
    $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".

    Line 61
    $cfg['Servers'][$i]['extension'] = 'mysqli';

    Line 71
    $cfg['Servers'][$i]['auth_type'] = 'http';
  4. Open php.ini from C:\php and add make the following changes

    Uncomment line 627

    extension=php_mbstring.dll

    A add a new line 648
    extension=php_mysqli.dll

    Edit Line 778
    mysqli.default_host = localhost

    Edit Line 781
    mysqli.default_user = root

Test

  1. Restart your computer. This fixes a weird error with loading mysqli.dll.
  2. Restart Apache.
  3. Open http://localhost/ in a web browser. If you see something like the following, Apache restarted successfully.
    Apache Test

    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.

    PHP Startup Error

    If rebooting doesn't work, try copying libmySQL.dll from C:\Program Files\MySQL\MySQL Server 5.0\bin to C:\WINDOWS\System32.

  4. 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.
    phpinfo page
  5. 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.
    PHPMyAdmin