Installing MySQL on Windows

Download MySQL Community Server from http://dev.mysql.com/downloads/mysql/. You can either download the web installer or the all-in-one installer. The web installer would download only those components that you have selected. The following instructions show the download options using the web installer.

The web installer first downloads a small application, and it gives you options to select the components that you want to install:

1. Select the Custom option and click on Next:

Figure 1.10: MySQL Installer for Windows

1. Select the MySQL Server and MySQL Workbench products and complete the installation. During the installation of the server, you will be asked to set the root password and given the option to add more users. It is always a good idea to add a user other than root for applications to use:

Figure 1.11: Select MySQL products and features to Install

1. Make sure you select All Hosts when adding a user so that you are able to access MySQL database from any remote machine that has network access to the machine where MySQL is installed:

Figure 1.12: Add MySQL user

1. Run MySQL Workbench after installation. You will find that the default connection to the local MySQL instance is already created for you:
   

Figure 1.13: MySQL Workbench connections

1. Click on the local connection and you will be asked to enter the root password. Enter the root password that you typed during the installation of MySQL Server. MySQL Workbench opens and displays the default test schema:

Figure 1.14: My SQL Workbench