Serverspace accelerated the answering of support requests by 40%
July 19, 2023
Updated July 27, 2023

Install mysql Windows Server

Databases Windows

A widely used DBMS for storing and organizing large volumes of data with high speed and performance is MySQL, which is an open-source system. It supports SQL language, allowing for various manipulations with databases, for instance, creating tables, modifying, deleting, inserting data. Additionally, MySQL supports the use of triggers, functions, and stored procedures. Its popularity comes from its ease of use, high performance, and wide variety of software available for working with it. Below we will discuss the installation process on the Windows Server 2019 operating system.

Preparatory work

To install the DBMS correctly, it is required to have Python package installed, in version not less than 3.7. It is necessary to download and install it on the server in advance. Additionally, it is desirable to update the operating system with the latest patches from Microsoft.

Screenshot №1. Python availability requirement

Download msi distribution from the site and install by following the installation wizard, almost everywhere by clicking "Next".

Downloading the MySQL Distribution

In order to start installing, we will download MySQL install files available on their website. Select "MySQL Installer for Windows" option, download and start the file on your server.

Screenshot №2. Download distribution for Windows

Starting the installation and selecting components

After the download is successfully finished, MySQL installer interface will appear on the screen. To install only MySQL, select "Custom". However, if we decide that need other Oracle products, choose "Developer Default". Please note that some components may depend on others, and if you do not select them, you will not get the necessary functionality of the system. It is needed to choose one of the options that is most suitable for the tasks of the server, in this case, select "Full" and click "Next" to proceed with the installation.

Screenshot №3.Choosing components for setup

On the next "Installation" page, click "Execute"

Screenshot №4.Ready for install

Configuring Connection Types

The next step is to set up connection types. If you need standard settings, leave the following items unchanged. At the stage of creating an administrator user, you will need to change its password. This account will be used to manage the MySQL system.

Screenshot №5.Type and networking setup screen
Screenshot №6. Authentication method setup screen
Screenshot №7. Setup superuser password screen
Screenshot №8. Setup as Windows service screen
Screenshot №9. Server file permissions setup screen
Screenshot №10. Apply configuration for install screen

Server setup

After the installation is complete, you need to configure the MySQL server. If there are problems, the installer will be able to provide detailed information about what needs to be configured.

Screenshot №11. Product configuration screen
Screenshot №12. MySQL router configuration screen
Screenshot №13. Connect to local server
Screenshot №14. Install complete screen

Checking the installation

Once the system is installed, we recommend testing performance of new installed server. This can be done using tool MySQL Workbench or any other database management software. Launch Workbench, and connect to the local server :

Screenshot №15.Start MySQL Workbench and connecting to local server
Screenshot №16. Connectiong to local DB

After connecting to the database, you can use the following query to check the version of the DBMS:

SELECT version();

The result will look like the screenshot below:

Screenshot №17.Invoke version check by SQL-query in Workbench

As a result, we can say that the installation was successful.


The main steps for installing this DBMS on a server were covered in this article. If you follow the mentioned steps carefully, installing MySQL on Windows Server 2019 should be a relatively simple process. In case you encounter any difficulties, or need further assistance, we recommend consulting the MySQL documentation or reaching out to the developer community for additional support.

4 out of 5
Аverage rating : 4
Rated by: 1
1101 CT Amsterdam The Netherlands, Herikerbergweg 292
+31 20 262-58-98
700 300
700 300
We use cookies to make your experience on the Serverspace better. By continuing to browse our website, you agree to our
Use of Cookies and Privacy Policy.