© Haptic, LLC- Summer sale is on! We're giving everyone 30% off their new server at checkout!
*30% off applies automatically at checkout for your first month. Ends September 30, 2026.
© Haptic, LLC*30% off applies automatically at checkout for your first month. Ends September 30, 2026.
RedMGuideBrowse and edit your RedM server's MariaDB database live from HeidiSQL, Navicat, or DBeaver through a secure SSH tunnel.
Every RedM server on Haptic has its own private MariaDB database. You can connect to it from your PC with HeidiSQL, Navicat, DBeaver, or any MySQL client that supports an SSH tunnel. The connection goes through the same secure address you use for SFTP, so your database is never exposed to the open internet. If you only need to run .sql files, the simpler Import SQL files flow needs no database program at all.
The tunnel reaches the database inside your running server, so a stopped server has nothing to connect to.
On the dashboard, go to Account → Settings and set a password in the SFTP section. This is its own password, separate from your Haptic login.
Open your server, click Connect via SFTP on the Files card, and look for the Database tools section. It shows the database name and lets you reveal the database password. The database user is haptic_cfx.
Create a new session with these settings:
Network type: MariaDB or MySQL (SSH tunnel)
SSH host + port: sftp-REGION.haptic.gg port 2022 (REGION is na-east, na-west, or eu-west, shown in your SFTP modal)
SSH username: your SFTP username, shown in the SFTP modal
SSH password: your SFTP password from Settings
Hostname / IP: 127.0.0.1
Port: 3306 (if you run MySQL or XAMPP locally, set the local forwarded port to 3307 instead)
User: haptic_cfx
Password: reveal it in the Database tools section
Database: shown in the Database tools section
Click Open. You are now looking at your server's live database: player characters, money, inventories, and whatever your scripts store.
Same idea: enable the SSH tunnel option in the connection profile, put your SFTP details in the SSH fields, then use 127.0.0.1:3306 with the haptic_cfx login for the database itself.
ssh -N -L 3307:127.0.0.1:3306 -p 2022 YOUR_SFTP_USERNAME@sftp-REGION.haptic.ggLeave that running, then point any MySQL client at 127.0.0.1:3307. You can verify the host key fingerprint at haptic.gg/sftp-fingerprints.
A common workflow: build and test your scripts locally against XAMPP, then move the data to your Haptic server.
Export your local database to a .sql file (phpMyAdmin → Export, or HeidiSQL → Export database as SQL).
Small files: connect with HeidiSQL through the tunnel and run the file against your server’s database.
Big dumps or lots of files: upload them to the server-data/sql folder in your Files tab and restart your server. They import automatically during startup. Full guide: Import SQL files.
Root access or other databases. The haptic_cfx user can only touch your own server’s database. CREATE DATABASE, DROP DATABASE, and switching databases are blocked on purpose.
Connecting without the tunnel. Port 3306 is not reachable from the internet. Any client that cannot do an SSH tunnel cannot connect directly; use the sql folder instead.
Connecting while the server is off. Power the server on first.
Connection refused: make sure the server is online and the SSH host matches your server’s region.
SSH login fails: reset your SFTP password in Settings and try again with the new one.
Locked out after failed attempts: too many wrong passwords locks SFTP for a while. Wait it out, or message us and we will clear it.
Tunnel connects but the database login fails: re-reveal the database password in the Database tools section; it is the haptic_cfx user, not your SFTP login.
Port 3306 already in use on your PC: forward to local port 3307 instead and point your client at 127.0.0.1:3307.
Message us on Discord with your server name, the client you are using (HeidiSQL, Navicat, and so on), and a screenshot of the error. We will get you connected.