MySQL Installation and Configuration

1. download mysql (mysql-5.5.13-win32.zip).
2. unzip it into C:\mysql-5.5.13-win32\
3.put c:\mysql-5.5.13-win32\bin in PATH
4. in cmd, mysqld.exe  (this will start mysql server)
5. mysql -u root -p   (this will login you in as root, the password is blank)
6. create database guestdb;   (this will create a database named as "gestdb")

You can change root password by using
UPDATE mysql.user SET Password=PASSWORD('') WHERE User='root'; 
FLUSH PRIVILEGES;
Now we have mysql good to go.