Technical Database Interaction
While the FREAKHOSTING Game Panel provides the underlying network connection, HeidiSQL is the industry-standard desktop client utilized to actually interact with your persistent data. This powerful, lightweight tool is essential for administrators who need to import.sql files for complex resources (such as job systems or dealership scripts) and for performing manual adjustments to player bank balances, inventory items, or administrative ranks.
Difficulty
Intermediate
Time
6 Minutes
Step 1: Establishing a Remote Connection
Follow these steps to link your local machine to your hosted database instance.Acquire the Client
Download and install the latest stable version of HeidiSQL.
Input Credentials
- Network Type: Select
MariaDB or MySQL (TCP/IP). - Hostname / IP: Enter your Database Endpoint (Found in the panel’s Databases tab).
- User / Password: Input your specific database credentials.
- Port: use the default
3306.
Step 2: Importing Resource Data
Complex FiveM scripts often include a.sql file (e.g., esx_vehicleshop.sql) designed to initialize the necessary tables and relationships.
Select Target Registry
In the HeidiSQL sidebar, click on your server’s database name to set it as the active context.
Open SQL Asset
Navigate to File -> Run SQL file… and select the
.sql file provided with your modification.Execute Logic
If a “Query” tab initializes, press the Execute (Blue Play button) or F9. The script will now programmatically build your database tables.
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 | FiveM: Database managed.