In this walkthrough we are going to look at installing and configuring MySQL to work with PHP on an IIS 6.0 web server. If you have not already installed PHP you can do so by following the steps in this article here (http://www.iisadmin.co.uk/?p=4)
Installing MySQL on the Server
Start by downloading MySQL. You can get the latest stable release version here :
In this tutorial I am going to be using the Windows Essentials (x86) version which has all the core functionality you need to run a MySQL database server. Launch the mysql-essential-5.0.26-win32.msi installer file to start the MySQL Setup Wizard.
Click Next and then choose a custom installation as this will allow us to specify an installation directory of our own choosing. In this example I will be using installing MySQL into the ‘C:\MySQL’ folder.
On the Custom setup dialog box click Change to specify the preferred installation directory.
Select the directory you want to use and then click OK to go back to the Custom setup dialog box.
Click next. MySQL is now ready to be installed. Click Install to begin the installation.