MIDAS KnowledgebaseMIDAS Knowledgebase

How to install & configure MariaDB on a Windows server

This article is from our multi-part series "How to install pre-requisites needed for running a self-hosted edition of MIDAS from a Windows server".

It applies to self-hosted installations of MIDAS on Windows-based servers only.

MIDAS requires either MySQL or MariaDB to be installed. This article outlines how to install MariaDB on Windows. Instructions for installing MySQL may be found here instead.

Please note that this article is provided "as is" and is correct at time of writing. For further assistance installing/configuring MariaDB, please refer to the vendor's own documentation/support.

This article assumes that you've already successfully completed our previous "How to install & configure Apache on a Windows server" and guide.

Contents:


Step 1 - Download MariaDB for Windows

MariaDB for Windows may be freely downloaded from MariaDB.org.

Download page on MariaDB.org

When you click the "Download" button, you'll be prompted to select the appropriate file for you operating system. For 32-bit Windows systems, select the "Windows x86 MSI Package". For 64-bit Windows systems, select the "Windows x86_64 MSI package:

Select MariaDB download type


Step 2 - Install MariaDB

Run the MariaDB Installer and read & accept the License Agreement. You'll then be prompted to select components to install and an install location:

MariaDB Custom Install

As a bare minimum, you'll need to install the MariaDB server and Database Instance. If in doubt, you can simply install all selected components.

The installer will then ask you to setup a "root" password for your database server:

MariaDB set root password

We also recommend that you select the "use UTF8 as default server's character set" option.

Next, you'll be asked whether you wish to install MariaDB as a Windows Service. You should select this option to ensure that MariaDB automatically runs whenever your Windows machine is turned on. You should also enable the networking option to ensure that your MariaDB server is accessible via your network:

Install MariaDB as a Windows service

Next, you may be prompted to decide whether you wish to allow anonymous usage statistics to be collected. It is your choice whether you enable this option or not:

MariaDB anonymous usage statistics

Finally, the installer will inform you that it's ready to install MariaDB. Click "Install" to proceed:

MariaDB Ready To Install

The installer will then install MariaDB....

Installing MariaDB on Windows

...and inform you when installation is complete:

MariaDB installed on Windows


Other Articles In This Series...


You might also be interested in...
MIDAS » KB » Support » Article 00197

← Return to Knowledgebase