Skip to main content

Remote Database Management

HeidiSQL is a powerful, open-source, and lightweight management tool specifically designed for MySQL and MariaDB databases. While our Game and Web panels provide integrated web-based database management, HeidiSQL offers a more strong environment for developers who need to perform complex SQL queries, manage large-scale data migrations, or synchronize local and remote tables. This guide will walk you through the secure connection process from your local workstation.

Difficulty

Beginner

Time

5 Minutes

Technical Prerequisites

Before initializing a connection, ensure you have prepared the following components.

Step 1: Retrieve Connection Credentials

Your connection details vary based on the hosting platform you are using.
  1. Log in to the Game Panel and select your server.
  2. Navigate to the Databases tab in the sidebar.
  3. Click the Eye Icon or the three dots next to your database entry to reveal the hidden credentials.
  4. Note down the Endpoint (Host), Port, Username, and Password.

Step 2: Configuring the Session

Follow these steps to link HeidiSQL to your remote database instance.
1

Initialize New Session

Launch HeidiSQL and click the New button in the bottom-left corner of the session manager.
2

Configure Network Type

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

Input Server Data

  • Hostname / IP: Enter your copied Endpoint address.
  • User: Input your unique database Username.
  • Password: Paste your secure database Password.
  • Port: use the default 3306 unless specified otherwise in your panel.
4

Open the Link

Click Open to establish the connection. The system will prompt you to save the session for future use.

Troubleshooting Connectivity

  • Access Control: Verify that your database user is permitted to connect from your local IP. In the Game Panel, use % in the “Connections From” field to allow access from any IP address temporarily.
  • ISP Blocking: Some local networks or ISP firewalls may block port 3306. Try using a VPN or contacting your network administrator.
Ensure there are no leading or trailing spaces in your username or password. We recommend clicking the “Copy” icon in our panel rather than manually highlighting the text.

Database Security

Remote database access provides full control over your data. Never use weak passwords or share your connection details with unauthorized individuals. Always use a secure, encrypted connection (SSL/TLS) if your project handles sensitive user information.

Need Extra Help?

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

Save on Your Hosting

Ready to get a new server? Use code KB20 at checkout for 20% off your first month!

Last Updated: January 2026 | Pro Tip: Keep your database credentials secure and never share them.