How to Install MySQL on Windows 10/ 11

In this post, we will see how to download and install MySQL on Windows 10/ 11. The current version is MySQL 8.0.42. We will also install MySQL Workbench.

Before moving further, we’ve prepared a video tutorial to install MySQL on Windows 10/ 11:

Let us first see the pre-requisites:

Pre-requisites

For MySQL to work correctly, at first you need to install Microsoft Visual C++ Redistributable for Visual Studio 2019. Let us download Microsoft Visual C++ Redistributable for Visual Studio 2019.

Visit the above link and go to Other Tools, Frameworks, and Redistributables and download as shown below:

Download MS Visual Redistributable x64

After downloading, install the Redistributable on your Windows 10 system.

Download MySQL

Step 1: Let us begin downloading the MySQL .msi file. To download the MySQL installer, visit the below link:

https://dev.mysql.com/downloads/installer/

From the link, go to “MySQL Community Downloads”, click the following MySQL version, and download “mysql-installer-community-8.0.23.0.msi”:

 Download MySQL MSI Installer

Install MySQL on Windows 10

Step 2: After downloading “mysql-installer-community-8.0.23.0.msi”, double click on the exe file. Installation begins, and you will reach the “Choosing a Setup Type” dialog box.

Select “Custom” and click Next:

Choosing MySQL setup type

Step 3: Now, you will reach the “Select Products” section.

Drag and drop the following from “Available Products” to “Products To Be Installed”:

Here’s the screenshot:

Select products MySQL server, workbench and shell

After dragging all 3 as shown above, click “Next”.

Step 4: Now, on clicking “Execute”, all the 3 products will get installed one by one:

Execute to install MySQL

Step 5: After execution completes, click “Next” and configure.

Now, you will reach the “Type and Networking” dialog box. Keep it as it is and click “Next”:

Type and Networking MySQL

Step 6: Now, you will reach the “Authentication Method” section.

Select “Use Strong Password Encryption for Authentication (RECOMMENDED) and click Next as in the below screenshot:

MySQL Authentication Method

Step 7: Now, you will reach the “Accounts and Roles” section.

Enter a password of your choice under “MySQL Root Password” and click “Next”:

Add MySQL PASSWORD Accounts & Roles

Above, you can also add a new user, but we will keep it the default i.e. root.

Step 8: Now, the “Windows Service” section can be seen. Keep it as it is and click “Next”.

MySQL Windows Service

Step 9: The “Apply Configuration” section is visible.

Click “Execute” to apply the confirmation steps as shown below:

MySQL Configuration Steps

Step 10: All the steps executed successfully with tick marks and MySQL installed as shown below:

MySQL installed successfully

Click “Finish”

Step 11: On reaching the next step, it automatically selected “Start MySQL Workbench” and “Start MySQL Server”. Keep it as it is and click “Finish”:

MySQL Installation procedure completed

The above will begin with the “MySQL Server” and “MySQL Workbench”.

Click on “Local instance MYSQL80” and enter the same password you created in Step 7 above:

MySQL Workbench started

After entering the password, click OK and you will enter Workbench.

Follow the below videos for MySQL Server and Workbench:

If you liked the tutorial, spread the word and share the link and our website Studyopedia with others.


Read More:

MySQL Introduction & Features
How to Install MySQL on MacOS
Studyopedia Editorial Staff
contact@studyopedia.com

We work to create programming tutorials for all.

No Comments

Post A Comment