Game servers
Your database
Every server has one MySQL database. Frameworks such as ESX and QBCore keep their data in it. Your server reaches it, and so can you, from your own computer.
Your database login #
Everything is under Login details:
| Login details | What it is |
|---|---|
| Database host | The address of the database |
| Database port | 3306 |
| Database name | Your database |
| Database user | Your database user |
| Database password | Hidden until you press Show |
When txAdmin's setup or a recipe asks for a database, give it these details, every one of them: a recipe's own
defaults (localhost, root, no password, a database name of its own) do not work here. Use your Database name
as it is, and turn Delete database off. The full list is in txAdmin.
Connect from your computer #
Any MySQL tool works. Two free ones:
- HeidiSQL (Windows): press New for a session, choose a MariaDB or MySQL (TCP/IP) network type, then fill in the host, user, password and port from Login details. On the SSL tab, tick Use SSL. Your database is on the left once connected.
- DBeaver (Windows, Mac, Linux): New Database Connection, choose MariaDB or MySQL, then fill in the host, port, database, user name and password from Login details. On the SSL tab, tick Use SSL.
Tip
Use SSL whenever you connect from your own computer. Your password and your data then cross the internet encrypted.
If your server is suspended #
SFTP closes as soon as a server is suspended. Your database stays reachable for 7 days, so you can export your data;
the suspended notice on the server's page says until when. After that the database is closed too. When the server is
unsuspended it gets a new database password under Login details: put it in the connection string in server.cfg
and restart the server.
Back up your database #
Server backups do not include the database. Back it up yourself from
your SQL tool, which can export the database to a .sql file on your computer (in HeidiSQL, Export database as SQL;
in DBeaver, Dump database). Do it before a big change, and keep the file somewhere safe.
A new database password #
Reset database password under Login details makes a new random password and shows it there. It asks for your account password (and your two-factor code if you use one).
Warning
Your server reads the database password from the connection string in server.cfg. After a reset, your server loses
its database until you put the new password in that connection string and restart the server. Only reset it when you
need to.
If you cancel #
When your server is deleted at the end of the time you paid for, its database is deleted with it. Export anything you want to keep before then.