Step 1. Download MySQL Installer (mysql-advanced-5.5.8-win32.msi) file from the website of MySQL
Go to URL http://www.mysql.com/downloads/mysql/
MySQL Installer provides an easy to use, wizard-based installation experience for all your MySQL software needs. Included in the product are the latest versions of:
MySQL Server
All of our support connectors
Workbench and sample models
Sample databases
Documentation
Step 2. After downloading the installer file e.g mysql-advanced-5.5.8-win32.msi
Open the file. It will start installer wizard. Please go throw the screen shot below.
Mostly you do not have to change the default setting, just continue with the wizard.
At this point, Note the port number. Default port number is 3306, If you wish you could change it else let go by default port number.
At this point, put password for security and note that password for login latter.
You are almost done...
Step 3. Now that MySQL is installed, You can confirm it by login to it.
Try through Start - All programms - My SQL.
If you cannot start the server through Start - All programms - My SQL
The best way to login without any problem is.
Go to command prompt. The folder where MySQL is installed.
Probably Program Files\MySQL\MySQL Server 5.5\bin
Use Command : mysql -u root -p
Put the password and you are in the database.