Hello, how are you today? This time we’re going to talk about the database. This is an electronic system that allows data to be easily accessed, manipulated and updated. In other words, is a usually large collection of data organized especially for rapid search and retrieval (as by a computer). Additionally, proper database management systems help increase organizational accessibility to data, which in turn helps the end-users share the data quickly and effectively across the organization. In simpler terms, the database allows for the organized collection of information. So that the user can access it at the time you want. There are many database management systems, like MySQL, phpMyAdmin, and MariaDB. But in this post, we are going to see how to install MySQL on Windows Server 2019.

Installing MySQL on Windows Server 2019

The first thing to do is to go to the official MySQL download page. Once there, we will download the msi installer. Choose your version and click “Download”. An option to be signup or login to an Oracle Web account will appear, but it can be skipped by clicking the “No thanks just start my download” link:

Download Windows MSI installer
Download Windows MSI installer

MySQL asks for requirements in order to work properly. However, the installer is very intuitive and will take care of satisficer such dependencies. Now, as a prerequisite you need has installed Visual Studio Code. If you don’t know how to do it, please check our post about Visual Studio

Starting MySQL Installer
Starting MySQL Installer

The installer’s initial window will then be displayed.

MySQL installer running
MySQL installer running

Next, it will be asked if we want to update the installer. If you answer yes, it will start downloading the update.

Downloading the installer update
Downloading the installer update

Configuring the installer

Next, we will see the installation options. You can choose to install the developer package, the server only, client-only, custom or the full package. In my case, I choose the client only, since it will allow taking advantage of the server and the tools of programming.

Choosing a Setup Type
Choosing a Setup Type

In the next window, the previously mentioned requirements appear. The installer will try to resolve most dependencies automatically. But to avoid issues with the installation, please download and install Visual C++ 2015 from here.

Installer configuring software requirements
Installer configuring software requirements

Please ignore the warning message and continue with the installation. In the next window, there will be a list of the components to download and install. Please Click on Execute

Components ready to download and install
Components ready to download and install

Just wait until components been downloaded and press Next to continue with the installation.

All of the components have been downloaded
All of the components have been downloaded

Configuring MySQL Server.

Furthermore, continues with the configuration of the product.

Starting to configure the products
Starting to configure the products

First, set up the MySQL server. Select between a Classic MySQL or a DB Cluster. In this case, I choose a Standalone MySQL server.

ServerĀ“s installation options
ServerĀ“s installation options

Next, configure the server type and connectivity. This should either be “Server Machine” in the case that you are installing MySQL on a server where other applications are installed or running. “Developer” if you want to do developing jobs or “Dedicated Machine” in the case that the server you’re installing MySQL on is to be dedicated to MySQL only and won’t be running any other applications/services. Please select Server Computer and the configuration relative to the connectivity can be left as it comes by default.

Setting up Type and Networking of server
Setting up Type and Networking of server

Now, choose the authentication method. Make the selection According to the version of MySQL you want to install both on the server and on the clients. Choose the recommended option and continue the process.

Selecting an Authentication Method
Selecting an Authentication Method

In the pop-up window, please fill in your username and password. In addition, the role assigned to the user to create.

Complete information
Complete information

Enter the newly created password, and check its strength.

Checking password strength
Checking password strength

Additionally, we are going to configure MySQL as a windows service. We will also assign a name to the service we will set the security level.

Setting MySQL server as Windows Service
Setting MySQL server as Windows Service

Once all the configurations are done, we finish the installer in order to apply the configuration.

Apply Configuration
Apply Configuration

Configuring MySQL router

The router’s configuration is already preconfigured. Just press finish to complete it. The optional configuration is only necessary if you are using an InnoDB cluster.

MySQL Router Configuration
MySQL Router Configuration

Configuring Samples and Examples

In this box, we verify the user’s connection to the server. With this intention, add the password and check the connection to the server. If everything is correct, a successful connection message will appear.

Applying configuration to sample
Applying configuration to sample

Finally, we finish the configuration.

Applying final configuration.
Applying final configuration.

When the installer has finished its work, we run the MySQL shell and the MySQL workbench.

MySQL Workbench running
MySQL Workbench running
MySQL Shell running
MySQL Shell running

Conclusions

In the final analysis, we have completed the installation of MySQL on windows server 2019. It has been a bit long, but successful. With this database, you can start programming, developing websites and much more. All right, that’s it for now. I really hope you find this tutorial helpful. Please visit the article about the SFTP server in Windows Server 2019. Join our Telegram channel for all the news about Windows 10 and mobile phones.

LEAVE A REPLY

Please enter your comment!
Please enter your name here