Skip to main content
To set up a database for a RedM server on FREAKHOSTING, click Databases, then Create database, and give it a name. On the database card, click Show next to the password, choose FiveM (oxmysql) under FORMAT and click Copy. Paste that set mysql_connection_string line into server.cfg above your ensure lines, start oxmysql before your framework, and restart.

Before you start

  • You need a database only for a framework such as VORP, or scripts that save data.
  • The oxmysql resource must be installed. The VORP txAdmin recipe includes it.
  • The FiveM (oxmysql) format works for RedM: both use the same oxmysql resource.

How to create a RedM database

1

Open Databases

Open your server in the Game Panel and click Databases in the sidebar.
2

Create the database

Click Create database and enter a name, for example vorp. The dialog shows the full name it will get, with a prefix. Leave Allowed to connect from on Anywhere and click Create database.
3

Show the password

On the new database card, click Show next to PASSWORD. The card shows HOST (port 3306), DATABASE, USER NAME and PASSWORD, each with Copy.
4

Copy the oxmysql line

Under FORMAT, choose FiveM (oxmysql) and click Copy. The line has your details filled in.

How to add the connection string to server.cfg

1

Open the raw file

Click Server config under FIVEM, then Advanced: open the raw file.
2

Paste the line

Paste the copied line above your ensure lines. Remove any older mysql_connection_string line. It looks like this:
3

Start oxmysql first

Make sure ensure oxmysql comes before your framework and scripts:
4

Save and restart

Save the file and restart the server.
Using a txAdmin recipe such as VORP? Enter the host, user name, password and database name from the card in the recipe’s database options. txAdmin writes the line into the recipe’s own server.cfg.

oxmysql connection string formats

The oxmysql documentation shows two formats and says to use only set, never setr:
The documentation lists characters to avoid in the password: ; , / ? : @ & = + $ #. If your password contains one, click Rotate password for a new one, or try the other format.

MariaDB or MySQL?

oxmysql’s documentation recommends MariaDB for compatibility and performance, and warns that many resources were written for MySQL 5.7 and can have problems on MySQL 8. The VORP recipe imports a file named MariaDB.sql.

How to import a resource’s .sql file

  1. On the database card, click Open in phpMyAdmin and sign in with the user name and password from the card.
  2. Select your database and open Import.
  3. Choose the .sql file from the resource and run it.
Run each resource’s SQL once, before the resource first starts. See how to manage databases.

Frequently asked questions

Why does oxmysql say it can’t connect?

Copy the line again from the card and check that it is above the ensure lines and that oxmysql starts first. After Rotate password, the old password stops working at once; copy the new line.

Do I need a separate database for each framework?

Use one database per server. Each framework and its scripts create their own tables inside it.

Are databases included in my backups?

Export the database in phpMyAdmin before big changes. Deleting a database removes all its data, and no backup of the database is kept.

How many databases can I create?

The Databases page shows how many you use and how many your server allows.

RedM server guide

Every RedM guide in one place.

Install VORP Core

Uses this database.

Install resources

Add oxmysql and scripts.

Manage databases

Rotate, open and delete.

Tested by the FREAKHOSTING team on our Game Panel on 2 November 2026 (RedM, FXServer build 38055 with txAdmin 8.1.2). oxmysql details checked against the official oxmysql documentation. Steps may differ slightly if the game changes.

Need Extra Help?

If you encounter any issues, our support team is ready to assist:

Save on Your Hosting

Ready to upgrade your hosting? Use code KB20 at checkout for 20% off your first order!

Last Updated: November 2026