How to Connect to Database using HeidiSQL

​

Remote Database Management

HeidiSQL is a powerful, free, and lightweight tool for managing MySQL and MariaDB databases. This guide will show you how to connect to your FREAKHOSTING database from your own computer.

​

Prerequisites

1. Download HeidiSQL: Available for free from the official HeidiSQL website.
2. Create a Database: Ensure you have already created a database in your management panel.

​

Step 1: Obtain Connection Details

​

From the Game Panel (Pterodactyl)

1. Log in to the Game Panel.
2. Select your server and navigate to the Databases tab.
3. Click the Eye Icon or the three dots next to your database to view the credentials.
4. Note down the Endpoint (Host), Port, Username, and Password.

​

From the Web Control Panel

1. Log in to the Web Panel.
2. Navigate to Databases.
3. Locate your database and copy the remote access host (usually provided in your welcome email for external connections).

​

Step 2: Configure HeidiSQL

1. Launch HeidiSQL on your computer.
2. In the bottom-left corner, click New.
3. Fill in the Session Name (e.g., “FREAKHOSTING Database”).
4. Configure the Settings tab:
   • Network type: MariaDB or MySQL (TCP/IP)
   • Hostname / IP: Enter the Endpoint you copied
   • User: Enter your Username
   • Password: Enter your Password
   • Port: Enter the Port (default is 3306)

5. Click Open to establish the connection.

​

Troubleshooting

​

Connection Refused?

• Remote Access: Ensure your database user is allowed to connect from your IP. In the Game Panel, use % in the “Connections From” field to allow all IPs.
• Firewall: Some local networks or ISP firewalls might block port 3306.
• Wrong Credentials: Double-check that there are no extra spaces when copying and pasting your password.