This guide shows you how to connect to your MySQL database using HeidiSQL, a popular and free database management tool.
Requirements
- HeidiSQL (free database client)
- Database created in your NolimitHost Game Panel
- Database credentials (hostname, username, password, port)
Step 1: Download and Install HeidiSQL
Download HeidiSQL
- Visit the HeidiSQL Download page
- Click the "Download" button to download the latest version
- Save the installer to your computer
Install HeidiSQL
- Run the downloaded installer
- Follow the setup wizard (you can accept all default settings)
- Complete the installation
Step 2: Get Your Database Credentials
From your Game Panel:
- Log in to your Game Panel
- Click on "Management" and select "Databases"
- Find your database in the list and note the following information:
- Hostname: Connection address/port (e.g., "db.nolimithost.cc:3306")
- Username: The database username
- Password: Click the key icon to reveal the password
- Database Name: Your database name
Step 3: Connect to Your Database
In HeidiSQL:
- Open HeidiSQL
- Click "New" to create a new connection
- Fill in the connection details:
- Hostname/IP address: Enter your hostname (usually something like "db.nolimithost.cc")
- Port: Enter the port number (usually 3306)
- User: Enter your database username
- Password: Enter your database password
- Click "Open" to connect
If the connection is successful, HeidiSQL will display your database structure on the left side.
Troubleshooting
Connection Refused: Make sure you're using the correct hostname, port, username, and password. Double-check that spaces or special characters aren't accidentally included.
Wrong Password: If you forgot your password, you can reset it from the Game Panel by clicking the key icon button on the database entry.
Next Steps
Once connected, you can manage your database tables, run queries, and perform backups directly from HeidiSQL.
