Follow us on Social Media:

MySQL Database Administrator

Boost Your Quick Knowledge in MySQL DBA Work, Concepts, Tips and Trick

Sunday, 22 April 2018

How to Install MySQL on Windows Environment

How to Install MySQL on Windows


The easiest way to install MySQl in Windows Machine is to download MySQL installer  from  https://dev.mysql.com/downloads/installer/

MySQL Installer provides an easy to use, wizard-based installation which included the latest versions of all components:

  • MySQL Server
  • MySQL Connectors
  • MySQL Workbench and sample models
  • Sample Databases
  • MySQL for Excel
  • MySQL Notifier
  • MySQL for Visual Studio
  • Documentation
First of all you have to choose right file which you have to download from the website\

  • If you have an online connection while running the MySQL Installer, choose the mysql-installer-web-community file.
  • If you do NOT have an online connection while running the MySQL Installer, choose the mysql-installer-community file.
Note: MySQL Installer is 32 bit, but will install both 32 bit and 64 bit binaries. 


Install MySQL via MySQL Installer

To install MySQL using the MySQL installer, double-click on the MySQL installer file and follow the steps below:

Install MySQL Step 1
Install MySQL Step 1: Windows configures MySQL Installer

Install MySQL Step 2 - Welcome Screen
Install MySQL Step 2 – Welcome Screen: A welcome screen provides several options. Choose the first option: Install MySQL Products

Install MySQL Step 3 - Download the latest MySQL products
Install MySQL Step 3 – Download the latest MySQL products: MySQL installer checks and downloads the latest MySQL products including MySQL server, MySQL Workbench, etc.

Install MySQL Step 4
Install MySQL Step 4: Click Next button to continue

Install MySQL Step 5 - Choosing a Setup Type
Install MySQL Step 5 – Choosing a Setup Type: there are several setup types available. Choose the Full option to install all MySQL products and features.

Install MYSQL Step 6 - Checking Requirements
Install MYSQL Step 6 – Checking Requirements

Install MySQL Step 7 - Installation Progress
Install MySQL Step 7 – Installation Progress: MySQL Installer downloads all selected products. It will take a while, depending on which products that you selected and the speed of your internet connection.

Install MySQL Step 7 - Installation Progress - Downloading Products in Progress
Install MySQL Step 7 – Installation Progress: downloading Products in progress.

Install MySQL Step 7 - Installation Progress - Complete Downloading
Install MySQL Step 7 – Installation Progress: Complete Downloading. Click Next button to continue…

Install MySQL Step 8 - Configuration Overview
Install MySQL Step 8 – Configuration Overview. Click Next button to configure MySQL Database Server

Install MySQL Step 8.1 - MySQL Server Configuration
Install MySQL Step 8.1 – MySQL Server Configuration: choose Config Type and MySQL port (3006 by default) and click Next button to continue.

Install MySQL Step 8.1 - MySQL Server Configuration
Install MySQL Step 8.1 – MySQL Server Configuration: choose a password for the root account. Please note the password download and keep it securely if you are installing MySQL database server on a production server. If you want to add a more MySQL user, you can do it in this step.

Install MySQL Step 8.1 - MySQL Server Configuration
Install MySQL Step 8.1 – MySQL Server Configuration: choose Windows service details including Windows Service Name and account type, then click Next button to continue.

Install MySQL Step 8.1 - MySQL Server Configuration - In Progress
Install MySQL Step 8.1 – MySQL Server Configuration – In Progress: MySQL Installer is configuring MySQL database server. Wait until it is done and click Next button to continue.

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

Install MySQL Step 8.2 - Configuration Overview
Install MySQL Step 8.2 – Configuration Overview: MySQL Installer installs sample databases and sample models.

Install MySQL Step 9 - Installation Completes

Now Installation has been completed . Just Click on finish to close installation wizard and login to MySQL client and enjoy .

No comments:

Please Like and Subscribe us ....

Please visit the website on daily basis , Your New articles will publish at any moment. Please Subscribe us for getting Latest Updates...