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 just installed .exe file.
- If
this window
appears, press "Install for all users". - If your computer asks you "Do you want this app to make changes to your device" click "Yes".
- 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"