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.
Execute the downloaded file and the installer will start. Just click on Next to continue the installation.
Then, accept the terms of the license.
In the next window select the components to install. The server, the development components, and the third-party tools. Please click next to continue
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.
In the next window, we will establish the server as a windows service. Also, we will assign the TCP port to allow the connection.
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.
Finally, the settings are complete and the installer can start its work.
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.
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.
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.
Once the configuration is finished, the server will start and we will be able to work with it.
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.
