Skip to main content

How to Connect to the Database from the Control Panel

To connect to the database from an application such as HeidiSQL, you need credentials (host, username, password). This guide retrieves the credentials from the Databases menu in the Control Panel.

USING DATABASE GUI?

If the database and user were created through Database GUI, the password is no longer shown in the panel. Follow How to Connect to the Database from Database GUI.

A. Get the Credentials from the Control Panel​

1. Open the Databases Menu​

  1. Log in to the Game Panel, then select your server.
  2. In the left sidebar, open the Server Settings group.
  3. Click the Databases menu.

Databases menu in the Control Panel

2. View the Credentials​

  1. On the database row, click the eye icon (👁).
  2. The Database connection details window will show:
    • Endpoint → the database host.
    • Username → the database user.
    • Password → the user password.
    • JDBC Connection String → a ready-to-use connection string.
  3. Click each value to copy it.
DON'T HAVE A DATABASE YET?

If the database is still empty, create one first via the Databases menu (click Create Database) or via Database GUI:

3. Required Credentials​

FieldGet from
Hostname / IPEndpoint of the database you viewed
UserUsername of that database
PasswordPassword of that database
Port3306

B. Connect with HeidiSQL​

1. Install HeidiSQL​

  1. Open the HeidiSQL download page.
  2. Download the latest Installer version, then install it on your computer.

2. Create a New Session​

  1. Open the HeidiSQL application.
  2. In the lower left panel, click New to create a new session.
  3. Fill in the session form:
FieldValue
Network typeMySQL (TCP/IP)
Hostname / IPEndpoint of the database you opened in the panel (example: db-host.raznar.net)
UserUsername of that database
PasswordPassword of that database
Port3306
  1. Click Save to save the session.

Filling in a new session in HeidiSQL

3. Connect​

  1. Select the session you just created.
  2. Click Open (or Connect).
  3. If successful, the status at the bottom will show Connected, and the database list will appear in the left panel.

Successfully connected to the database

4. If the Connection Fails​

  • Access denied for user → recheck the username and password. Make sure the user is granted access rights via Grant All Access or use the credentials from the Databases menu.
  • Can't connect to MySQL server → make sure the host (Endpoint) and port (3306) are correct, and that your account is connected to the internet.
  • Unknown database → make sure the database name has been created in Create Database.
  • Still failing? Contact the Technician / Hosting Admin via a ticket along with the error message that appears.

Next Steps​