Installing MySQL on Windows

There are too many ways in installing MySQL. But for me, its better to install the mysql-nointall any version. Because it is the best way to have a better control in your MySQL and in your system.


Follow the steps:


Step 1:
Download mysql-noinstall-5.1.63-win32 on http://www.mysql.com/.




Step 2:
Extract the ZIP archive in any of your partition. And name the folder mysql.




Step 3:
Create a new folder naming mydata. And copy the data folder in mysql folder to mydata folder.




Step 4:
After copying the data folder. Create an option file. Name it my.ini.


Write it inside the my.ini file.

Step 5:
After creating an option file. Paste it in your system through windows folder.




Step 6:
Open the command prompt and ENJOY!!!