Hey, how’s it going? Let is continue talking about database management systems. In a previous article, we saw how to install MySQL on Windows Server 2019. In this opportunity, we will see how to work with MariaDB. Indeed, MariaDB is an open-source relational database management system (DBMS) that is a compatible drop-in replacement for the widely used MySQL database technology. Additionally, both database management systems have their followers. So, let’s see how to install MariaDB on Windows Server 2019

Installing MariaDB on Windows Server 2019

In the first place, go to the MariaDB website to download the MSI file.

MariaDB Download Site
MariaDB Download Site

Execute the downloaded file and the installer will start. Just click on Next to continue the installation.

MariaDB setup wizard

Then, accept the terms of the license.

End-User License Agreement
End-User License Agreement

In the next window select the components to install. The server, the development components, and the third-party tools. Please click next to continue

Selecting the components to be installed
Selecting the components to be installed

Immediately, enter the password for the root user. In like manner, select Use UTF8 as default serverĀ“s character. Then press next to continue the installation.

Configuring the root password
Configuring the root password

In the next window, we will establish the server as a windows service. Also, we will assign the TCP port to allow the connection.

Installing MariaDB as windows service
Installing MariaDB as windows service

Next, the installer will ask if we wish to send anonymous usage statistics. Likewise, you can select this option or not and continue with the installation.

Select if you want to submit anonymous usage info
Select if you want to submit anonymous usage info

Finally, the settings are complete and the installer can start its work.

You can begin the installation or move back to change settings
You can begin the installation or move back to change settings

Once the wizard has finished its work, the installation is complete. The MariaDB server will have been successfully settled. You will be asked to restart to complete the installation.

Setup completed
Setup completed

Launching HeidiSQL

Now let’s test the functioning of the server. To do this, we will run HeidiSQ. This is an open-source program that allows you to manage databases quickly and easily. The database manager works locally on the user’s computer, so there are no size limitations. So, double click on the direct access and the welcome screen of the program will be opened. Being the first time we run the program, we have to add a new server or import it.

Session manager. Add a new server or import it.
Session manager. Add a new server or import it.

Please enter the name of the server (choose any name). In like manner, add the user (root) and the previously created password. Then, press open to start the server.

Entering server credentials.
Entering server credentials.

Once the configuration is finished, the server will start and we will be able to work with it.

HeidiSQL running
HeidiSQL running

Conclusion

As you can see, the procedure to install MariaDB on windows server 2019 is very simple. This is an open-source alternative to MySQL. And it has a significant number of users at the development level. All right, that’s it for now. Please visit our article on Xampp on Windows Server 2019. Be the first to know about our updates by joining our Telegram channel. Please visit our Facebook page.

LEAVE A REPLY

Please enter your comment!
Please enter your name here