How install and configure mysql 5.6.16 in windows 7

Question

I downloaded the zip file for Mysql 5.6.16, but there is no .exe file in the folder. All the instructions online are saying install through .msi file. How can i install and configure mysql 5.6.16 in windows 7 ?? Thanx in advance

Answer 1

As described in How to install MySQL on Windows 7?:

The installer installs the following software in your computer
a.) MySQL Server
b.) MySQL Connectors
c.) MySQL Workbench and sample models
d.) MySQL for Excel
e.) MySQL Notifier
f.) MySQL for Visual Studio
g.) Sample Databases
h.) Documentation

1. Download the installer here : http://dev.mysql.com/downloads/windows/installer/

2. There are two options available: (as on 31 Jan 2014 , the latest version is 5.6.16)

   (i) mysql-installer-web-community-5.6.16.0.msi – 1.5MB

   (ii) mysql-installer-community-5.6.16.0.msi – 250.8MB

3. I personally prefer the 2nd option. This helps me to keep the .msi file as backup in my computer. I can install MySQL whenever I need to even if I am offline.

4. After downloading the 250 MB file, double click it to start the installation process. Now it is simple as installing any software on windows 7.

5. Once you are done with the installation download the official document

   Direct link for A4 size pdf – http://downloads.mysql.com/docs/refman-5.6-en.a4.pdf

6. Now click the “MySQL Notifier” in programs menu. The Notifier icon appears in the task bar (right bottom). Right click on the small red icon and select “start” the server option.

7. Click the “MySQL Workbench” in the programs menu. Start creating databases/schemas/tables/SQL scripts.