Skip to main content

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.msc and 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 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".