Setting up a Database User

This page will cover setting up a database user on a Windows MariaDB Server instance using the popular database GUI HeidiSQL

Connect to your database

Then click Tools on the top-navbar, and click User Manager

Select "Add" and fill out the credentials.

Username: adminpanel (or your preference)

Host: % or the IP of the connecting user (more secure)

• Using % will allow any IP to connect (assuming they use the correct username/password)

Password: Set a secure password, you are exposing your database to the internet.

Click the checkbox next to Global Privileges, then hit save.

Allowing connections over port 3306/tcp

Next, we will go over opening port 3306 via the windows advanced firewall manager.

You know you are in the right spot once you see:

Click New Rule on the right side

Then fill out the configuration as follows:

• What type of rule...?

  • Port

  • Click Next

• Does this rule apply to TCP or UDP?

  • TCP

• Does this rule apply to all local ports....?

  • Specific local ports: 3306

  • Click Next

• What action....?

  • Allow the connection

  • Click next

• When does this rule apply?

  • Leave all checked

  • Click Next

• Name (does not actually matter, for your own records)

  • 3306 TCP

  • Click Finish