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

Install MySQL

Prerequisites

On the MySQL download page, click on "Pick a mirror" for the latest Windows (x86) version (40.0MB). Registering is optional. Scroll down and select a mirror to start downloading.

Version: 5.0.24a
File Name: mysql-5.0.24a-win32.zip
Download Location: http://dev.mysql.com/downloads/mysql/

Note: If you plan on installing phpBB, I recommend using MySQL 4.1. There's a thread on the phpBB forum about installing with MySQL 5.0.x (Thanks to John H. for pointing it out).

Install

  1. Run setup.exe from mysql-5.0.24a-win32.zip.
  2. Click Next >.
    Click Next >
  3. Select "Typical", and then click Next >.
    Select "Typical", and then click Next >
  4. Click Install.
    Click Install
    Installing
  5. Select "Skip Sign-Up", and then click Next >.
    Select "Skip Sign-Up", and then click Next >
  6. Leave "Configure the MySQL Server now" option checked. Click Finish.
    Click Finish
  7. Click Next >.
    Click Next >
  8. Select "Standard Configuration", and then click Next >.
    Select "Standard Configuration", and then click Next >
  9. Leave "Install As Windows Service" checked.

    Also check "Include Bin Directory in Windows PATH", and then click Next >.
    Check "Include Bin Directory in Windows PATH", and then click Next >
  10. Enter a root password. Make sure to remember this password. Click Next >.
    Enter a root password, and then click Next >
  11. Click Execute.
    Click Execute
  12. Click Finish.
    Click Finish

Test

  1. Open a command prompt & type in the following command.
    mysqlshow -u root -p
    Enter the password you supplied earlier. You should see something like the following:
    Command Prompt