Install MySQL

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

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 >.
  3. Select “Typical”, and then click Next >.
  4. Click Install.
  5. Select “Skip Sign-Up”, and then click Next >.
  6. Leave “Configure the MySQL Server now” option checked. Click Finish.
  7. Click Next >.
  8. 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 >.
  10. Enter a root password. Make sure to remember this password. Click Next >.
  11. Click Execute.
  12. Click Finish.
  13.  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: