Instructions on how to install MySQL on Windows 11 computers

As you all know, MySQL is one of the most affordable solutions for handling databases. And if you are doing a project that requires you to store and manipulate data, then MySQL is a database system that is very suitable for your needs.

So in this article, I will show you how to install MySQL on Windows 11 operating system so that you can do it yourself easily.

#first. Install MySQL Server on Windows 11

+ Step 1: First, to install and use MySQL on your computer, you need to install Microsoft Visual C ++ 2019 Redistributable first. You access the link here to download:

=> Then choose you 32bit or 64bit to suit the Windows platform you are using. You can see how to check if your Windows is 32bit or 64bit if you don't know yet!

Instructions on how to install MySQL on Windows 11 computers Picture 1

+ Step 2: After downloading, double click on the downloaded file to proceed with the installation => an installation window will appear as shown below => select I agree to terms and conditions => and Click the Install button to perform the installation.

Maybe the User Account Control box appears, click Yes to agree.

Instructions on how to install MySQL on Windows 11 computers Picture 2

You wait a moment for the installation process to finish, and after the installation is complete, click Close to close the program window. So you have successfully installed the Visual C ++ Redistributable package.

Instructions on how to install MySQL on Windows 11 computers Picture 3

+ Step 3: Now we will install MySQL on the computer. You access your address below to access the official MySQL download page:

https://www.mysql.com/downloads/

=> Then you scroll down => and click the MySQL Community(GPL) Downloads button to continue.

Instructions on how to install MySQL on Windows 11 computers Picture 4

Continue, go to Community Downloads => click on the option MySQL Community Server to continue.

Instructions on how to install MySQL on Windows 11 computers Picture 5

A new interface appears, choose Go to Download Page

Instructions on how to install MySQL on Windows 11 computers Picture 6

And click the Download button in the larger version.

Instructions on how to install MySQL on Windows 11 computers Picture 7

You choose No thanks, just start my download to continue.

Instructions on how to install MySQL on Windows 11 computers Picture 8

+ Step 4: Okay, now you have successfully downloaded the MySQL installer, double click on this file to proceed with the installation.

Instructions on how to install MySQL on Windows 11 computers Picture 9

Wait a moment for the program to work with the computer system. Maybe the User Account Contro window will appear, choose Yes.

Instructions on how to install MySQL on Windows 11 computers Picture 10

+ Step 5: Okay, now we will be taken to the installation setting of MySQL, with the following options:

1. Developer Default: Select this option to install MySQL server and necessary tools for MySQL application development. Specifically, the settings include MySQL Shell, MySQL Router, MySQL Workbench, MySQL for Visual Studio, MySQL Connectors and MySQL Server.
2. Server Only: Only install MySQL Server. Select this option when you want to deploy a MySQL server but not develop MySQL applications.
3. Client Only: This option will install all the tools included in the Developer Default setup with the only exception of MySQL Server. Select this option if you want to develop an application for an existing server.
4. Full: This option includes all MySQL products along with samples, examples, and documentation of the tools.
5. Custom: With this option, you can manually set up all the tools, depending on your usage needs.

=> Please choose the type of setting that suits your needs, here I will choose Developer Default. If you want to set it up in a Custom style, you can refer to this article!

Instructions on how to install MySQL on Windows 11 computers Picture 11

In the next interface, select Execute to start installing the selected tools.

Instructions on how to install MySQL on Windows 11 computers Picture 12

After the installation tools are successful, there will be a notification status as shown below, click Next.

Instructions on how to install MySQL on Windows 11 computers Picture 13

+ Step 6: In this step, we will choose the type of server on the computer. There are 3 styles for you to choose from:

1. Development Computer: If you are running several servers and applications on your machine then this is the most suitable option for you, as MySQL uses the least memory of these 3 options.
2. Server Computer: Choose this type of server when you are running some other server applications along with MySQL. Memory usage is moderate.
3. Dedicated Computer: If you do not run any other server on the machine, select this option. At this point MySQL will maximize the available memory.

=> Please choose the type of server that suits your needs, if not sure, it's best to leave it as default => then click Next.

Instructions on how to install MySQL on Windows 11 computers Picture 14

+ Step 7: If you are creating a new server, then check Use Strong Password Encryption for Authentication.

NOTE: If you already have applications that cannot use the SQL 8 connector and driver or recompiling the existing application is not possible, then select Use Legacy Authentication Method.

Instructions on how to install MySQL on Windows 11 computers Picture 15

This is the step to create a password, enter the password. Alternatively, you can also click the Add User button to create a user account in this step.

Instructions on how to install MySQL on Windows 11 computers Picture 16

If you want to create User Accounts, enter the user's name. You can set up similar to the image below.

Instructions on how to install MySQL on Windows 11 computers Picture 17

In case you don't want to create a User yet, click Next to move on to the next step.

Instructions on how to install MySQL on Windows 11 computers Picture 18

+ Step 8: At default setting, SQL Server will run as Windows Service suitable for most cases.

In case you don't want to run it as a Windows Service, uncheck Configure MySQL Server as a Windows Service and configure it yourself in the following steps. If you are not familiar with the settings, then I think you should leave the default.

Instructions on how to install MySQL on Windows 11 computers Picture 19

In addition, you can:

1. Windows Service Name: Rename the server instance.
2. Start the MySQL Server at System Startup: Check this option if you want to start MySQL with the system.

=> Then you click Next to continue.

Instructions on how to install MySQL on Windows 11 computers Picture 20

You select Execute in the next window to apply the configuration settings.

Instructions on how to install MySQL on Windows 11 computers Picture 21

+ Step 9: In this step is to configure MySQL Router. If you do not need to use it, just uncheck the line Bootstrap MySQL Router for use with InnoDB cluster => and click Finish.

Instructions on how to install MySQL on Windows 11 computers Picture 22

On the next screen, select Next

Instructions on how to install MySQL on Windows 11 computers Picture 23

At the Connect to Server screen, enter the password you set in the previous step in the Password box => then click Check to check.

Instructions on how to install MySQL on Windows 11 computers Picture 24

If ok, the status will be displayed as shown below.

Instructions on how to install MySQL on Windows 11 computers Picture 25

You click the Execute button on the Apply Configuration screen

Instructions on how to install MySQL on Windows 11 computers Picture 26

Then you choose Finish

Instructions on how to install MySQL on Windows 11 computers Picture 27

At the Product Configuration screen => you choose Next

Instructions on how to install MySQL on Windows 11 computers Picture 28

Thus, the process of installing MySQL on Windows 11 is complete. Click Finish to close the installation window.

Instructions on how to install MySQL on Windows 11 computers Picture 29

#2. Conclude

So I have finished showing you how to install MySQL on Windows 11. All in all, it's not complicated at all, right?

Marvin Fry

Update 16 January 2022