Install and Configure MySQL 5 on Windows
MySQL Server is one of the most popular database servers in the world, especially for use with dynamic, content rich websites. in fact the website you are looking at now is powered by MySQL. This guide will walk you through all the steps needed to both install and configure your MySQL 5 server on your Windows machine. Make sure you read the steps carefully as they explain why you should and shouldn't enable some options, and if your get stuck you can always get help right here in our forums. Lets get on with the guide...
First step is to download the latest MySQL install package from the MySQL site. There are several packages to chose from, but for general usage I recommend you use the Windows Essentials package. Once you have downloaded the installer package double click on it to initilize the installation wizard as shown below in figure 1.
The first step in the installation wizard will be to choose the setup type. Here I recommend using the Custom option so that you can define your installation path. Once you have this selected press the Next button as shown below in figure 2.
Use the Change botton in the lower right hand side of this window to specify your installation path, and I generally recommend using a path without spaces. Leave the installtion values as the default and click the Next button as shown below in figure 3.
You do not need to have or create a MySQL account to use MySQL, so unless you wish to do otherwise I recommend you select the Skip Sign-Up option and click the Next button as shown below in figure 4.
This completes the installation phase of your MySQL server setup. Ensure that the Configure the MySQL Server now option is checked and click the Finish button to complete the installtion wizard and start the configuration wizard.