MySQL Server on Windows
A MySQL server is needed for various applications and can contain important data for example for a game server or a website. In the following we explain how to set up your own MySQL database server on your Windows VPS or Rootserver.
Begin of the installation process
At the beginning you connect via remote desktop connection to your server and download the latest version of MariaDB, which is used for the database server: MariaDB Download.
Unpack the downloaded archive with WinRAR or 7Zip and start the installation file with a double click:
Afterwards you navigate through the installation process by clicking on Next until you are asked to type in the root password:
There you can define the master password for the access to your database server. Please make sure that you use a secure password which no one else knows!
IMPORTANT! If you want to access the database externally via Navicat, HeidiSQL or any other tool you have to activate the option Enable access from remote machins for root user! For security reasons this is generally not recommended.
Afterwards you click on Next until you reach the end of the installation, there you then have to click on Install:
Your database server is now online and ready to use!
Open the MySQL ports for an external connection
If you have enabled "Enable access from remote machins for root user" during installation, you must also specify the MySQL port 3306 in the Windows-Firewall. To do so, open it and create a new rule there which you add as follows:
Now you can access your MySQL server externally!