How to install MariaDB server on Windows

MariaDB is an open-source relational database that serves as a fork of the popular MySQL database. Originating from MySQL's original developers, MariaDB is known for its enhanced performance and robustness, making it a preferred choice for many developers.

Installing MariaDB on Windows is straightforward, thanks to the MSI package provided by the MariaDB Foundation. The package contains all the necessary tools, binaries, and libraries required for a smooth installation process.

While the process is quite intuitive, following the steps closely ensures that MariaDB is correctly installed, and its services are properly set up to start automatically with Windows.

1. Visit the official MariaDB downloads page.
2. Download the latest MSI package suitable for your Windows version.
3. Run the downloaded MSI installer.
4. Follow the installation wizard, selecting default options or customizing based on your requirements.
5. When prompted, set a password for the root user.

   This is the administrative account for the database, ensure you remember or store this password securely.

6. Ensure the checkbox for starting the MariaDB service is selected.
7. Complete the installation process by clicking the finish button.
8. Launch the MariaDB shell to verify the installation.

   $ mysql -u root -p

   After launching the shell, you'll be prompted to enter the root password you set during the installation.

9. Check the version to ensure MariaDB is installed correctly.

   MariaDB [(none)]> SELECT VERSION();

Congratulations, you've successfully installed MariaDB on your Windows system! With MariaDB now installed, you can start building, testing, and deploying your database applications with ease.