Tutorial Gateway

  • C Language
  • Java
  • R
  • SQL
  • MySQL
  • Python
  • BI Tools
    • Informatica
    • Tableau
    • Power BI
    • SSIS
    • SSRS
    • SSAS
    • MDX
    • QlikView
  • Js

Install MySQL on Windows

by suresh

In this article we will show you, Step by step procedure to install MySQL on Windows. It will be same for the Mac as well. To install MySQL on Windows, double-click on the msi file that we downloaded in Download MySQL article.

Based on the security configuration, it might ask you for the permission to run. Please click Run button to install MySQL on windows from the below shown pop-up message.

Install MySQL on Windows 1

Install MySQL on Windows

Once you click the Run, a new installation wizard called MySQL Installer Center will be opened. Before you start installing MySQL on windows platform, please read the Licence Agreement, and check mark the I accept the Licence terms option.

Install MySQL on Windows 3

Choosing Setup Type: Please select the Setup Type

Install MySQL on Windows 4

If you are only working with MySQL, or want to learn MySQL then you can select the Custom option. This will also save the disk space.

Install MySQL on Windows 5

After selecting the Custom option, Please select the MySQL Server, Workbench from Available Products. And then add them to Products/Features To Be Installed. This will add the Server, and workbench to write queries.

Install MySQL on Windows 6

We need all the available products from MySQL so, we are selecting the Developer Default option. If you had more space, please select this option.

Install MySQL on Windows 7

While installing MySQL on windows, it will leak you to install Python as well. As you can see, we don’t have python installed on this system. To demonstrate this message, we just uninstalled Python from our system.

Install MySQL on Windows 8

When we click next button, it is throwing a confirm message box. Click Yes. Remember, you will get this message even if you don’t have Visual Studio, or any other supporting software’s.

Install MySQL on Windows 9

Click Execute Button to install MySQL on windows. This includes all the products that you selected before.

Install MySQL on Windows 10

As you can see, products are installed successfully. Click Next button.

Install MySQL on Windows 11

Product Configuration: Until now, we installed the MySQL Server, Workbench, and remaining products on our windows. Now we have to configure the Server, Router, and add Samples and Examples to it.

Install MySQL on Windows 12

Type and Networking: Please select the first option, and click Next.

Install MySQL on Windows 13

Server Configuration Type: Use this page to configure the server type, Port number. As you can see from the below screenshot, Config type had three types:

  • Development Machine: If you select this option, You can use this software as any other software, and consumes less memory. Standard option.
  • Server Machine: If you are configuring Server-Client then you can use this option. So that, only server application will run in this system.
  • Dedicated Machine: If you want to dedicate this machine to MySQL server then use this option. It will not allow any servers such as web server in this machine.
Install MySQL on Windows 14

We selected the default Development machine as the config type, and default port number 3306. You can change them as per your requirements.

Install MySQL on Windows 15

Please provide the password for the root account. This is the password that you are going to use to login to MySQL from command prompt, or in workbench.

Apart from the default root account, you can add your own users to access MySQL by clicking the Add User button

Install MySQL on Windows 16

Here, we are adding tutorialgateway user with DB Admin rights. We will write a dedicated post about the Roles, and its access levels.

Install MySQL on Windows 17

As you can see, we provided random password for the user

Install MySQL on Windows 18

Now, you can see a new user tutorialgateway

Install MySQL on Windows 19

Windows Service: This will add MySQL Service to the windows services, and the service will start when the windows is loading.

Install MySQL on Windows 20

For now, we are not enabling the protocol. So, we are leaving as it is, and clicking Next button

Install MySQL on Windows 21

Click on the Execute button to apply configurations.

Install MySQL on Windows 22

Click Finish button to finish configuring the MySQL Server

Install MySQL on Windows 23

Let me configure the Router

Install MySQL on Windows 24

We will do the Router Configuration in later stage. For now, we are leaving the defaults. Feel free to change them as per your requirements.

Install MySQL on Windows 25

Now, Let me configure the Samples and Examples

Install MySQL on Windows 26

Please provide the password to connect to the MySQL Server

Install MySQL on Windows 27

Click on the Execute button to run the scripts that are required to add Samples, and Examples to MySQL.

Install MySQL on Windows 28

From the below screenshot you can see that configuration steps are executed without any error.

Install MySQL on Windows 29

Click Finish button to close the Installer wizard. This completes the installing MySQL on windows.

Install MySQL on Windows 30

Hope you understood the steps that are required to install MySQL on windows along with Workbench, and connections. Below screenshot will show you MySQL Command prompt, and Workbench.

Install MySQL on Windows 31

Placed Under: MySQL

Trending Posts

SSIS FTP Task Delete Local Files

MDX Head Function

JavaScript SetUTCHours

Java pow Function

SQL Server Reporting Services

Create a SSIS Project

JavaScript getUTCDate Function

Python For Loop

C program to Print Hollow Square Star Pattern

Excel Source in Informatica

  • C Programs
  • Java Programs
  • SQL FAQ’s
  • Python Programs
  • SSIS
  • Tableau
  • JavaScript

Copyright © 2019 | Tutorial Gateway· All Rights Reserved by Suresh

Home | About Us | Contact Us | Privacy Policy