Databases

Creating a Database

• Database Name: set the Name of the Database, this is normally not important. Usage of only a-z is recommended.
• Connections from: set the allowed IPs or Hostnames that can access the Database. Leave blank to allow from everywhere.

After Creation

On the Top you can see the view when a Database has been created. You have the following options:

• Export to SQL: Exports the Database to a .sql file, you can reimport this later and keep it as a backup or import it somewhere else.
• Import from SQL: Imports a .sql file, if any errors occur please make a Ticket.
• View (eye icon): View Full Details of the Database.

Usage

On the Bottom you can see the Full Details, you can see the host, user and password you need to access the Database. If you want to see data in the Database by yourself, you can use any MySQL or MariaDB program, a popular choice is HeidiSQL A Connection string for FiveM needs to be usually formatted like this: mysql://<user>:<password>@<host>/<name>, where:

• User: the user that is shown in the Full Details page.
• Password: the password that is shown in the Full Details page.
• Host: the endpoint that is shown in the Full Details page.
• Name: the database name, this is shown in the normal view (in the example images it is s539_example).

From the Example Images this results in: mysql://u539_8zwghnVTml:0WWJoyble5R2bSq=Debbpfi@193.70.81.157:3306/s539_example