A MySQL server is needed for various applications and can hold important data, for example for a game server or a website. Below, we explain how to set up your own MySQL database server on your Windows Dedicated Server.
First, connect to your server via Remote Desktop and download the latest version of MariaDB, which is used for the database server: MariaDB Download.
Extract the downloaded archive using WinRAR or 7Zip and start the installation file by double-clicking it:
Then proceed through the installation process by clicking Next until you are prompted to enter the root password:
Here you can set the master password for accessing your database server. Make sure to choose a secure password that no one else knows!
IMPORTANT! If you want to access the database externally using Navicat, HeidiSQL, or another tool, you must enable the option Enable access from remote machines for root user! For security reasons, this is generally not recommended.
Then continue clicking Next until you reach the end of the installation, and click Install there:
Your database server is now online and ready to use!
If you enabled “Enable access from remote machines for root user” during installation, you also need to open the MySQL port 3306 in the Windows Firewall. To do this, open the firewall and create a new rule.
You can find instructions for forwarding ports in the firewall here: Port Forwarding (Firewall)
Now you can access your MySQL server externally!