Install MySQL 6.0 on Windows 7

Download the copy of mysql from here. and store in on your Hard Drive.

1.       1.Double click on the setup file.

2. Click on Next

3.       3.Choose from the options available,for basic stuff select  “Typical” click on Next.

4.   The screen shows the Installation Path, and the Data Folder path. The Data Folder path is a usually a Hidden folder that contans the User’s details and access details to the Root user account in a .ini file. Click on Install.

5.Click on Next.

6.Click on Next.

7.You can uncheck the second option by now, if you are in hurry.

8.This will open the MySQL Server Instance Configuration Wizard.Click on Next.

9.Check on the Standard Configuration,Detailed Configurations has options for  Optimal use of Memory by MySQL Server.

10.Installing MySQL as a Windows service is recommended for Windows 7.And if you want to run the SQL commands via Command Prompt,Check the second option to Include the Bin Directory in WINDOWS PATH .Click on Next.

11.Enter ROOT password of your choice and click on next.

12.If you are installing MySQL for the first time, it will not ask for your current root  password.

 Whenever you uninstall MySQL from your machine, the.ini  file present in the hidden folder C:\ProgramData\MySQL  as discussed in the step 4 is not deleted,so the next time you repair/re-install MySQL  it will ask you for the current root password. If you do not remember the root password,simply delete the MySQL folder from  C:\ProgramData\MySQL, before starting the installation. 

13.Click on Execute Button.

 

14.Click on finish.That’s it!!! You have sucessfully Installed MySQL. To start writing you own DB programs, Go to START>>All Programs>>MySQL>>MySQL Command Line Client.

15. Enter the root password you have set during installation and press Enter .

16.You need to select a particular DB Name for use.

mysql DB is already created for you. Type  use mysql;

Bonjour Start firing your SQL Queries.

17. To create you new Database instance, write create database “databasename”;.

18.To Change your command line point to your newly created Database, type use databasename;.