How to install MySQL in Windows 7

This article on how to install MySQL on Windows 7 . Before we begin, I like you to determine the system type - whether your computer is 32 bit or 64 bit.You can know the system type from the "Control Panel" -> "System and Security" -> "System".

Download MySQL installer file

Be sure to choose the MySQL installer file that corresponds to your system type. For me, it was the mysql-essential-5.1.40-winx64.msi file from the MySQL.com web site. I chose the essentials file because it is sufficient for my needs. However, there is nothing stopping you from picking the bulky Windows MSI Installer if you want.

Instructions to install MySQL on Windows 7

The process of installing MySQL is not very difficult, so don't be intimidated by the large number of points; I just wanted to be thorough.

• Start MySQL installation by double-clicking the .msi file - click "Run" when prompted.Click "Next" button in the introductory window.
  

• In the following screen, select Custom installation which will allow you to specify the folder to which MySQL will be installed. You can go ahead with a Typical MySQL setup but this will put MySQL deep down in the "Program Files" folder.

• Click the "Change" button and enter C:\MySQL in the Folder name field. Hit "OK" when done .

• The installer will change the MySQL installation folder to the one specified by you.

• You are now ready to install MySQL on Windows 7 operating system. Click "Install".

• It would take some time for the progress bar to move ahead... be patient .

• You may also get messages along the way - simply click on "Next" to proceed.

• When the process finishes, you'll get to see the final screen. Congratulations - MySQL has been installed on your computer. You are now prompted to Configure the MySQL server and register the product. In the interest of time, I had unchecked the second box and clicked "Finish".
  

• MySQL instance configuration is important - you cannot use the software until you do so. Click "Next" to proceed.

• Select "Detailed Configuration".Choose "Developer Machine".

• I suggest going ahead with "Multifunctional Database" unless you know what you are doing .

• In the following screen, don't mess with the default values and click "Next".

• The same goes for the subsequent screen - click "Next".

• For the networking options configuration, put a check mark in front of "Enable Strict Mode" if it's not there .

• Yes, it's recommended to install MySQL as a Windows service and have the system include the MySQL bin directory in the Windows PATH variable.

• The password for the MySQL server instance has to be typed in twice. Remember to keep a note of it - Don't lose this MySQL password.

• The configuration wizard has received all the information it needs and is ready to create a MySQL server instance. Click "Execute" button .

• The instance should be configured without problems.