# 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](https://www.heidisql.com/)

## Connect to your database

<figure><img src="/files/2J8FgKcZhZRYgmaoWwg0" alt=""><figcaption></figcaption></figure>

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

<figure><img src="/files/tOXX1LTsU3L9aGyd54Pv" alt=""><figcaption></figcaption></figure>

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.

<figure><img src="/files/KXHWsA16BPCdH5L01JHO" alt=""><figcaption></figcaption></figure>

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

{% hint style="success" %}
Your database user has been successfully created, be sure to save these credentials somewhere safe.
{% endhint %}

## Allowing connections over port 3306/tcp

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

<figure><img src="/files/jDJvybtZ3mf6HRvwIBOL" alt=""><figcaption></figcaption></figure>

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

<figure><img src="/files/wm7tqbJtR64thLmkfxhb" alt=""><figcaption></figcaption></figure>

Click New Rule on the right side

<figure><img src="/files/e7fpn0uhyDI9GXd0n8qd" alt=""><figcaption></figcaption></figure>

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


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.ivs.dev/resources/admin-panel/guides/setting-up-a-database-user.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.