setting up Drupal development environment on Windows XP

1. Download and install WAMP
- http://www.wampserver.com/en/download.php (or google download WAMP
2. Download and install Drupal
- Start with tutorial --- http://drupal.org/node/176025
- http://drupal.org/files/projects/drupal-x.x.tar.gz , choose version , download
- unzip the folder to C:\wamp\www , so that the following folder C:\wamp\www\drupal-5.2
structure should be available
3. Start the WAMP
Start - Programs - WAMP Server - start Wamp Server
- check functionality firefox http://localhost/
- start sqllite manager firefox http://localhost/sqlitemanager/
- login with the default root for the database cd "C:\wamp\mysql\bin" , mysql -u root mysql
4. Create the database (C:\wamp\www\drupal-5.2\INSTALL.mysql.txt
- logon to mysql CLI mysql -u root -p

NOTE: THE COMMAND ENDS AT THE MYSQL PROMT WITH ; NOT SIMPLY ENTER
- command to create the database
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE
TEMPORARY TABLES, LOCK TABLES
ON first.*
TO 'username'@'localhost' IDENTIFIED BY 'pass';

Query OK, 0 rows affected (0.01 sec)

- flush the previliges
FLUSH PRIVILEGES;

Query OK, 0 rows affected (0.01 sec)

5. Run the install script

firefox http://localhost/drupal-5.2/install.php?profile=default

6. Create the database for the Drupal installation
- in the mysql prompt -- create database dbDrupal;
- show all created databases --- show databases;
-
7. Fill up the textfields on the site with the data used so far:
Database name: dbdrupal
Database username: username
Database password: pass
press Save configuration : You should see the
Drupal installation complete

8. Procede with http://localhost/drupal-5.2/
- check the Drupal status http://localhost/drupal-5.2/?q=admin/logs/status
- some problems are displayed , click on files , click on create the following structure is created C:\wamp\www\drupal-5.2\files

9. How to change the password for a user in mysql prompt
mysql default username is root and default pass is mysql
so one has to login with the following command mysql -u root and type the password mysql when prompt
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newVerySecrtePass');

10. Annoyed for searchiing for the path of mysql -- add C:\wamp\mysql\bin to the path

11. Go to http://localhost/drupal-5.2/
- Configure your website
- create admin root , pass Extremely secret
- go to administration section , configure other users
-



SOURCES:
URL
URL
URL
URL