Database
In this guide I will be explaining how to install MariaDB in combination with HeidiSQL to manage your server's database.
MariaDB
Download MariaDB
- Download MariaDB from the official website (opens in a new tab)
- Select MariaDB Server Version 11.4.4
- Select "Windows" as "Operating System"
- The website should now look like
this
- Leave the "mirror" default
- Press "Download"
Install MariaDB
Now that we have installed the MSI file, its time to install the application.
- Run the MSI file
- Press next
- Tick the box for License Agreement and press next
- Leave the settings default, press next
- You can either choose to untick the box to continue without a password or create a password, that is up to you. If you have done that press Next again
- Leave all the settings default and press next
- Press "Install"
- If your computer asks you "Do you want this app to make changes to your device" click "Yes".
- Once that is done you should be able to click "Finish".
- To make sure that MariaDB is properly installed, we will go to
services.msc
and look for "MariaDB" - If you followed all these steps, MariaDB should be present in the services like
this
HeidiSQL
Download HeidiSQL
- Download HeidiSQL from the official website (opens in a new tab).
- Click Installer, 32/64 bit combined.
- Save the executable (.exe) to your download location and press "Save"
Install HeidiSQL
- Open the
.exe
file we just installed. - Select the option for I accept the agreement and press next.
- Leave the destination Location default and press next.
- Press next again on the Select Start Menu Folder option.
- For the Select Additional Tasks you can decide what options you want to turn on. Press next again.
- Press "Install"
- Click "Finish"