This page will show you how to install, configure and run mySQL 5 under Microsoft Windows. If you have an older version of mySQL installed on your system, It's a good idea to uninstall it first dan don't forget to backup...

1. Download The Latest Version of mySQL 5

Download and install the latest version of MySQL 5.0.x from http://dev.mysql.com/downloads/mysql/5.0.html. Just make sure you get a Windows 2000/XP/2003 (x86) binary, Windows Essentials (x86) version (skip all the questions part and scroll down to the mirrors list).

2. Install MySQL 5 Windows Essentials (x86)

Run the MSI file and use the following settings

• Run mysql windows essentials
• Select TYPICAL setup
• Skip Sign-Up
• Make sure "Configure the mySQL Server Now" is checked
• Select "Detail Configuration"
• Select Dedicated mySQL Server Machine
• Select Multifunctional Database
• On "InnoDb TableSpace Settings" page, leave everything default
• Select "Decision Support (DSS)/OLAP"
• make sure "Enable TCP/IP Networking" is checked and leave the port number at 3306 (at this point, if you have a firewall, it will usually try to access itself on the localhost)
• Select "Standard Character Set"
• Check marked "Install As Windows Service"
• "Include Bin Directory in Windows PATH" is checked recomended
• Enter your root password. To leave password blank, uncheck "Modify Security Setting"
• Click EXECUTE button and mySQL will be setup