Categories
FiveM

How to Setup Your Database

What Is a Database?

A database is a place for your server to store it’s data in an organised way that it can read and use later on. You will need a database to store your player’s data, such as the items they have, their money and more.

How to Create a Database

  1. Head to the Iceline Panel and click on your server.
  2. To the left of your server, go to the “Databases” tab.
  3. To the right of this page, put any name into the “Database” blank.
  4. Press “Create Database” towards the bottom. You don’t need to put anything into the “Connections” blank.

How to Connect Your Database to Your Server

  1. Head to the game panel and stop your server.
  2. Make sure you have the latest version of mysql-async installed on your server.
  3. In your server’s server.cfg file, insert the following line
  4. set mysql_connection_string "server=localhost;uid=mysqluser;password=password;database=fivem"
  5. Change the details in the connection string to your database details, you can find them under the database tab.

Facing Any Issues?

If you are still having issues, please double-check the information you have entered into the server.cfg, if you mistyped or misformatted the details, it will not work correctly. If you are still having issues after this, feel free to contact Iceline Hosting’s support for further assistance.

Leave a Reply