Getting Started with your Database

Wondering how to connect to your database on our Game Control Panel?

There are currently two ways at the moment. (Our web-based phpmyadmin or any Database Management Tool)

We'll be using HeidiSQL as our Database Management Tool in this example.

Refer to the correct tools below.

phpMyAdmin

Any database created on our network has a specific ip address assigned to it. (Unless you're using a VDS that has it's own local IP address)

You can use our internal phpMyAdmin link located here.

Once you've navigated to the website, please enter your username/password.

If you are using our Game Control Panel, these credentials are located in your Databases tab.

HeidiSQL

HeidiSQL is another alternative method. It can be downloaded here.

After you've installed HeidiSQL on your local PC, you will need to connect to the remote server on secured.gg.

Firstly, you will be greeted with an empty main menu.

To start a new connection, make sure you press the "New" button to add a new server.

HeidiSQL Main Menu

After pressing "new", the program will ask if you'd like to name your connection; go ahead and do so. (You can name it whatever you want)

Databases

Once the connection has been named, let's move on to the actual connection details on the right side.

There are five main important details you need to connect to the server (Hostname/IP, Username, Password, Port, and Database)

Database Connection Details

Navigate back to the Game Control Panel and click the Databases tab

Let's start inputting in the details based on the game control panel credentials.

Database Name: Shown on the left.

Endpoint: The database IP address and port (":" Separates the IP Address from Port)

Username: The database username.

Password: Located in the "eye".

Database Connection Details

Going back to HeidiSQL, it would look something like this.

Database Connection Details

Once entering in all the credentials, we will press the "Save" Button to save our configuration.

This will save the credentials to the Session Name that you specified earlier (Easier to connect back to next time, instead of entering in your credentials again)

Database Connection Details (HeidiSQL)

Done! Press open and you will be greeted with your database tables!