Zum Hauptinhalt springen

Share externally

Why do I need to share the database externally?​

To sync your files to our system, we need to connect to your database, but our systems only need read permissions on the table from your FiveM server.

See also, Creating users in the database

Share database from Linux server externally​

First, connect via SSH to your server where the database is running.

Next you need to edit the MySQL server config, you can find it in the following locations:

  • For MySQL community servers it is this command: nano /etc/mysql/mysql.conf.d/mysql.cnf
  • For MariaDB servers it is this command: nano /etc/mysql/mariadb.conf.d/50-server.cnf

Once in the config file, look for the following line: bind-address            = 127.0.0.1

Now edit this line to: bind-address            = 0.0.0.0

Now save these changes using the following key combinations: STRG+X Y Enter

Now shutdown your game server (e.g. your GTA server).

Now you have to enter the following command in your SSH console to restart your database server and apply your changed data: service mysql restart

Now you can restart your game server and your database has been shared externally.

Share database from a Windows server externally​

First, in your Remote Desktop connection, click on the Windows logo or magnifying glass in your server taskbar and enter the following: Windows Defender Firewall with advanced security

When you are there, click on the top left: Incoming rules Now click there on the top right: New rule...

Now select the following: Port

Now select TCP and enter the following port for "Specific local ports": 3306

Now you select this: Allow connection

It is important that you leave all three checkmarks set in the next step (Domain, Private, Public). At the name for the new rule you enter e.g. MySQL.

Now click on: Finish

Your database has been shared externally.