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
- Download HeidiSQL from the official HeidiSQL website. It runs on Windows; the project also offers a native Linux build and a macOS build for Apple silicon Macs.
- Have a database ready:
- Game server: create a database in the Game Panel.
- Website on the Web Panel: create a database in the Web Panel.
- VPS or dedicated server: install MariaDB or MySQL and create a database and user.
Step 1: Find your connection details
- Game Panel
- Web Panel
- VPS / dedicated server
- Open your server and click Databases in the sidebar.
- On the database’s card, copy the Host, Database and User name with their Copy buttons.
- Click Show next to Password and copy it.
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:
3306unless 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 on127.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.exefrom 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 (22unless 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.Troubleshooting HeidiSQL connections
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 typeMariaDB 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 as3307, so it does not clash with a MySQL server on your own computer.
Does HeidiSQL work with PostgreSQL?
Yes. ChoosePostgreSQL (TCP/IP) or PostgreSQL (SSH tunnel) as the network type and use port 5432.
Related guides
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:- Live Chat: Quick assistance via our website.
- Support Ticket: Open a Ticket
- Discord: Join our Community
- Email: support@freakhosting.com
Last Updated: November 2026