Skip to main content
To connect HeidiSQL to a MySQL or MariaDB database, open HeidiSQL, click New, set Network type to MariaDB or MySQL (TCP/IP), enter the host, user name, password and port (usually 3306), then click Open. For a database on your own VPS or dedicated server, choose MariaDB or MySQL (SSH tunnel) instead, so the database never has to be open to the internet.

Before you start

Step 1: Find your connection details

  1. Open your server and click Databases in the sidebar.
  2. On the database’s card, copy the Host, Database and User name with their Copy buttons.
  3. Click Show next to Password and copy it.
The Host contains the address and port together, for example 203.0.113.10:3306. In HeidiSQL, put 203.0.113.10 in Hostname / IP and 3306 in Port.The database must allow logins from Anywhere. A database set to One address only accepts only that one address.

Step 2: Connect with TCP/IP (Game Panel and Web Panel)

1

Create a session

Open HeidiSQL and click New in the bottom-left of the session manager. Give the session a name, for example Game server DB.
2

Set the network type

Set Network type to MariaDB or MySQL (TCP/IP).
3

Enter the details

  • Hostname / IP: the host address only, without :3306
  • User: the database user name
  • Password: the database password
  • Port: 3306 unless your panel shows another port
4

Open the connection

Click Save, then Open. Your databases appear in the tree on the left.

Step 3: Connect through an SSH tunnel (VPS and dedicated servers)

An SSH tunnel sends the database connection through your SSH login. MySQL can stay on 127.0.0.1 with port 3306 closed in the firewall, and the traffic is encrypted.
1

Create a session

Click New and set Network type to MariaDB or MySQL (SSH tunnel).
2

Fill in the Settings tab

  • Hostname / IP: 127.0.0.1 (the database as seen from the server itself)
  • User and Password: your database user, for example shopuser
  • Port: 3306
3

Fill in the SSH tunnel tab

  • SSH executable: select plink.exe from the list (the HeidiSQL installer includes it)
  • SSH host and port: your server’s IP, for example 203.0.113.10, and your SSH port (22 unless you changed it)
  • Username: your Linux login, for example alex
  • Password or private key: your SSH password, or your key file
  • Local port: a free port on your PC, for example 3307
4

Open the connection

Click Save, then Open. HeidiSQL starts the tunnel, then connects through it.
plink.exe is part of PuTTY and uses PuTTY’s .ppk key format. If your key is in OpenSSH format, convert it with PuTTYgen first. See use PuTTY and create SSH keys.
If you need a direct TCP/IP connection to a VPS instead (for example from another server), follow allow remote MySQL connections first.

Troubleshooting HeidiSQL connections

Remote database access gives full control over your data. Use strong passwords, never share connection details, and do not open port 3306 to everyone on your own server. Prefer the SSH tunnel for VPS and dedicated servers.

Frequently asked questions

Can I use HeidiSQL with a game server database?

Yes. Use the Host, User name and Password from the database’s card in the Game Panel, with the network type MariaDB or MySQL (TCP/IP).

Is there a way to manage my database without installing anything?

Yes. The Game Panel and Web Panel both include phpMyAdmin in the browser. On a VPS you can install phpMyAdmin yourself.

Why does the SSH tunnel need a local port?

HeidiSQL starts the tunnel on that port on your PC and connects to it. Pick any free port, such as 3307, so it does not clash with a MySQL server on your own computer.

Does HeidiSQL work with PostgreSQL?

Yes. Choose PostgreSQL (TCP/IP) or PostgreSQL (SSH tunnel) as the network type and use port 5432.

VPS and dedicated server guides

Every guide in this section.

Game Panel databases

Create a database for plugins.

Web Panel databases

Databases and remote access for websites.

Create a database and user

Set up a login on your VPS.

Allow remote connections

Open MySQL to one IP safely.

Connect with SSH

The login the tunnel uses.

Checked against the official HeidiSQL help and our current Game Panel and Web Panel database pages on 4 November 2026; the localhost user over a 127.0.0.1 connection tested on Ubuntu 24.04 LTS with MariaDB 10.11. HeidiSQL menus can change between releases.

Need Extra Help?

If you encounter any issues, our support team is ready to assist:

Save on Your Hosting

Ready to upgrade your hosting? Use code KB20 at checkout for 20% off your first order!

Last Updated: November 2026