Setup Drupal on Windows XP Pro using IIS

While trying to install Drupal on stand alone machine with Windows XP Pro & IIS I was unable to find all the installation information at one place therefore I am sharing my experiences and solutions to the problems. I think it will be useful for people who are new to Drupal because Drupal on stand alone machine reduces the learning curve.

Setup Drupal on Windows XP Pro using IIS:
1. Download Mysql server and install. (I have used ver. 5.0)
2. Download PHP and install. (I have used ver. 4)
3. Download Drupal (I have used ver. 4.7.3).
4. Create a folder with any name for example Drupal in Inetpub folder in C: drive.
5. Open IIS and create virtual folder giving alias and path of the Drupal folder which you have just created in Inetpub.
6. Untar (you can use Winrar for this) the downloaded drupal file contents in Drupal folder.
7. Create a schema/database with any name example drupaldata and create a user.
8. Now grant privileges to this user.
Grant ALL ON databasename.*
TO 'username'@'localhost' IDENTIFIED BY 'password';
Flush privileges;

9. Modify the file C:\Inetpub\wwwroot\[YOURDIRNAME]\sites\default\settings.php by giving user name, password and database name.

10. Now browse this virtual folder with its alias name in IE example http://localhost/"aliasname"

11. If following error is displayed;
Client does not support authentication protocol requested by server; consider upgrading MySQL client

Then use these commands;
SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('newpwd');
Flush privileges;

12. Repeat step 10, I hope its working ….

Have a look at one of the pretty clean theme implementation in drupal - ENJOY . . .