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.
- Select MariaDB Server Version 11.4.4.
- Select "Windows" as "Operating System".
- Leave the "mirror" default.
- Press "Download".
Install MariaDB
- 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.mscand look for "MariaDB". - If you followed all these steps, MariaDB should be present in the services.
HeidiSQL
Download HeidiSQL
- Download HeidiSQL from the official Website.
- Click
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.
- 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 agreementand press next. - Leave the
Destination Locationdefault and press next. - Press next again on the
Select Start Menu Folderoption. - For the
Select Additional Tasksyou can decide what options you want to turn on. Press next again. - Press "Install".
- Click "Finish".