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:
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
The installer’s initial window will then be displayed.
Next, it will be asked if we want to update the installer. If you answer yes, it will start downloading the 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.
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.
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
Just wait until components been downloaded and press Next to continue with the installation.
Configuring MySQL Server.
Furthermore, continues with the configuration of the product.
First, set up the MySQL server. Select between a Classic MySQL or a DB Cluster. In this case, I choose a Standalone MySQL server.
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.
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.
In the pop-up window, please fill in your username and password. In addition, the role assigned to the user to create.
Enter the newly created password, and check its 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.
Once all the configurations are done, we finish the installer in order to apply the 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.
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.
Finally, we finish the configuration.
When the installer has finished its work, we run the MySQL shell and the MySQL workbench.
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.