How to install MySQL for Microsoft Windows

Summary: In this post, We will show you how to install MySQL on Microsoft Windows via the MySQL Installer package. After this short tutorial, you will have a MySQL server setup and the extra tools up and running on your operating system and to also help you learn in a lab enviroment.

Your going to need to download the MySQL installer.
The installer package can be found here  http://dev.mysql.com/downloads/installer/

  • If you are connecting to the internet while installing MySQL, you can choose the online installation version  mysql-installer-web-community-<version>.exe .
  • In case you want to install MySQL offline, you can download the  mysql-installer-community-<version>.exe  file.

Install MySQL using the MySQL Installer

To install MySQL via the MySQL installer package first double-click on the MySQL installer file and then follow the steps shown below.

Install MySQL Step 1

Install MySQL.
Step 1: Windows configures MySQL Installer

Install MySQL Step 2 - Welcome Screen

Install MySQL.
Step 2 – The Welcome Screen: The welcome screen give you several different options. Choose the first option: Install MySQL Products

Install MySQL Step 3 - Download the latest MySQL products

 

Install MySQL.
Step 3 – Download the latest updated MySQL products: MySQL installer will check and download the latest MySQL product updates including MySQL server, MySQL Workbench and other required components.

Install MySQL Step 4

Install MySQL
Step 4: Click the Next button to continue to the next step.

Install MySQL Step 5 - Choosing a Setup Type

Install MySQL
Step 5 – Choose your Setup Type: there are 5 setup types available on the next screen. Choose the Full option to install all of the MySQL products and features.

Install MYSQL Step 6 - Checking Requirements

Install MySQL.
Step 6 – Checking the Requirements.

Install MySQL Step 7 - Installation Progress

Install MySQL.
Step 7 – The Installation Progress Bar: The MySQL Installer will now download all the products you selected. It will take time so be patient. The amount of time it takes to install depends on which products you checked and the speed of the internet connection you are using.

Install MySQL Step 7 - Installation Progress - Downloading Products in Progress

Install MySQL.
Step 7 Continued – The Installation Progress: downloading Products in progress.

Install MySQL Step 7 - Installation Progress - Complete Downloading


Install MySQL
Step 7 Continued – After the Installation Progress: Completed Download. Now click the Next button to continue…

Install MySQL Step 8 - Configuration Overview

Install MySQL
Step 8 – The Configuration Overview Details. Next, click the Next button to configure the MySQL Database Server component.

Install MySQL Step 8.1 - MySQL Server Configuration

Install MySQL
Step 8.1 – The MySQL Server Configuration: Now choose the Config Type and the MySQL port. 3006 is the default port which you may also need to configure in your routers NAT settings. Now click Next the button to continue with the installation.

Install MySQL Step 8.1 - MySQL Server Configuration

Install MySQL
Step 8.1 – The MySQL Server Configuration: Now choose a new password for the root account. Note the password download and keep it secure place if you are going to install the MySQL database server in a production enironment. If you need to add a extra MySQL users it can be done it in this step.

Install MySQL Step 8.1 - MySQL Server Configuration

Install MySQL.
Step 8.1 – The MySQL Server Configuration. You can now choose the Windows service details which includes the Windows Service Name and account type. Now then click Next button to continue.

Install MySQL Step 8.1 - MySQL Server Configuration - In Progress

 

Install MySQL.
Step 8.1 – The MySQL Server Configuration – In Progress bar: The MySQL Installer is now configuring the MySQL database server. Please wait until it is completed and then click the Next button to continue.

Install MySQL Step 8.1 - MySQL Server Configuration - Done

Install MySQL
Step 8.1 – The MySQL Server Configuration – Done. Click the Next button to continue.

Install MySQL Step 8.2 - Configuration Overview

Install MySQL.
Step 8.2 – The Configuration Overview: MySQL Installer will now install the sample databases and sample models.

Install MySQL Step 9 - Installation Completes

Install MySQL.
Step 9 – The will Installation will now Complete.
Now click the Finish button to close the installation wizard and launch the MySQL Workbench.

In this post on how to install MySQL you will have learned how to install MySQL on your Microsoft Windows operating system via the MySQL installer.