How To Install MySQL On Windows?

We’ll learn how to download and install MySQL on Windows in this post.

There are many types of relational databases that exist in today’s world, including MySQL, one of the most popular ones.

With its support for multi-user access, the storage engine provides a wide range of options.


To install MySQL – It requires the following requirements to be installed on your system:

  1. Setup file to install MySQL.
  2. The Microsoft .NET Framework version 4.5 is required to install MySQL.
  3. Visual Studio Redistributable Package for Microsoft Visual C++ are also required to install MySQL.

Install MySQL:

  • For MySQL installation instructions for linux, please click here.
  • If you are using a Mac, please visit our article on How To Install MySQL On Mac OS.

Step 1: The first step is to download the community server edition software from the official MySQL website.

Step 2: The setup can be downloaded in two ways. You can choose the MySQL community server version number you want. Mysql-installer-web-community is a suitable choice if you have high-speed internet connectivity. Otherwise, choose mysql-installer-community.msi. Please refer to the image below:

download and install mysql

Step 3: Simply double-click the MSI installer file once you have downloaded the setup file. You will see the following screens:

install mysql gathering info

Step 4: Next, select the Setup Type. Installing MySQL product and features requires choosing the appropriate option from a variety of available options. We will select the Full option and click Next.

install mysql step4

The following will be installed: MySQL Server, MySQL Shell, MySQL Router, MySQL Workbench, MySQL Connectors, documentation, samples and examples, and much more.

Step 5: It may inform us that some features cannot be installed on your system because of missing requirements once we click on the Next button. Clicking on the Execute button will automatically install all requirements or we can skip them. Click on Next.

install mysql step 5

Step 6: A dialog box will appear in the next wizard asking for our confirmation to install a few products. The Yes button must be clicked here.

install mysql step 6

The list of products that will be installed will appear after clicking the Yes button. Click the Execute button if all products are needed.

install mysql step 6.1

Step 7: By clicking on the Execute button, all the products will be downloaded and installed. Click Next once the installation is complete.

install mysql step 7

Step 8: Next, we must configure the MySQL Server and Router. Due to the fact that MySQL does not require the Router – Firstly, we will configure the server, then we will configure the router. Click the Next button.

install mysql step 8

Step 9: You will see the screen below as soon as you click on the Next button. In this step, we will configure the MySQL server. Select Standalone MySQL Server/Classic MySQL Replication from the list and click on Next. Depending on your needs, you can also select the InnoDB Cluster.

install mysql step 9

Step 10: The next screen will ask you to choose the configuration type and other connectivity options. The Config Type is ‘Development Machine’, and the Connectivity is TCP/IP, and the Port Number is 3306, then click Next.

install mysql step 10

Step 11: Click on Next after selecting the Authentication Method. In the image below, we have selected the first option.

install mysql step 11

Step 12: You will be asked to enter the MySQL Root Password – Click the Next button after filling out your password details.

install mysql step 12

Step 13: To start the server, you must configure the Windows Service. Click Next and keep the default settings.

Step 14: Next, you will be asked to apply the Server Configuration. You can execute this configuration.

install mysql step 14

Step 15: Upon completion of the configuration, you will see the screen below. To continue, click Finish.

install mysql step 15

Step 16: A completed Product Configuration screen appears next. To complete the MySQL package installation, keep the default settings and click Next then Finish.

install mysql step 16

Step 17: The next wizard allows us to configure the router. Click Next and Finish and then Next.

install mysql router step 17

Step 18: Next, we’ll see the option to connect to the server. The root password that we set earlier must be mentioned here. By clicking on the Check button, you can also determine whether or not the connection was successful. If the connection is successful – Click Next once the configuration is complete.

install mysql step 18 router root password

Step 19: Next, select the applied configurations and click Execute.

install mysql step 19 router

Step 20: The following screen will appear once we have completed the above step. Click the Finish button here.

install mysql step 20 router

Step 21: The MySQL installation on your windows system is now complete. Just click Finish.

install mysql step 21 router

Now you know how to install MySQL on Windows – You are done with MySQL installation on Windows. To test your MySQL with python visit our python mysql article.

We value your feedback.

Subscribe To Our Newsletter
Enter your email to receive a weekly round-up of our best posts. Learn more!

Leave a Reply

Your email address will not be published. Required fields are marked *