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.- Acquire HeidiSQL: Download and install the latest stable version from the official HeidiSQL website.
- Initialize Your Database: Ensure you have already Created a Database within your management panel.
Step 1: Retrieve Connection Credentials
Your connection details vary based on the hosting platform you are using.- Game Panel (Pterodactyl)
- Web Control Panel
- Log in to the Game Panel and select your server.
- Navigate to the Databases tab in the sidebar.
- Click the Eye Icon or the three dots next to your database entry to reveal the hidden credentials.
- 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.Initialize New Session
Launch HeidiSQL and click the New button in the bottom-left corner of the session manager.
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
3306unless specified otherwise in your panel.
Troubleshooting Connectivity
Connection Refused / Timeout
Connection Refused / Timeout
- 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.
Access Denied Errors
Access Denied Errors
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.
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: [email protected]
Last Updated: January 2026 | Pro Tip: Keep your database credentials secure and never share them.