On the FiveM settings page you can enter your database credentials. These database settings are required when starting to use the application.
In the “FiveM server settings” section you can enter your FiveM Server IP & Framework. The correct framework type is required for querying users in the database.
These are your database settings.
The easiest way to set this up is to create a new database-root user. This can be done with the SQL command below. You need to execute this in a database brwoser (eg PHPMyAdmin, HeidiSQL).
CREATE USER 'perdonit_user'@'%' IDENTIFIED BY '<INSERT_PASSWORD>';
GRANT ALL PRIVILEGES ON *.* TO 'perdonit_user'@'%';
If running MariaDB (XAMPP uses MariaDB) make sure the database is set to public facing. In the c:/xampp/mysql/my.cnf make sure the line with bind-address=0.0.0.0 is uncommented.
Many hosting providers have documentation on where to find your database information. Some of the populair once are listed here, you can also try to find the documentation for your provider using google Database settings.
| Hosting | Link |
|---|---|
| Zaphosting | https://zap-hosting.com/guides/docs/gameserver-database-external-access/ |
| Vibegames | https://help.vibegames.com/en/article/connect-your-server-to-a-database-1ph0vzt/ |
After you have your database settings you can enter them in the Perdon FiveM Settings fields:
| Input name | Description | Example |
|---|---|---|
| FiveM database ip | This is the ip-address of your database. This cannot be a private IP (localhost, 127.0.0.1, 192.168.###.###, …).Note that TCP-port 3306 should be open | 175.18.211.19:3306 |
| FiveM database user | This is the username of your database. | perdonit_user |
| FiveM database password | The password of your database user | <INSERT_PASSWORD> |
| FiveM database name | This should be the name of the database. This is the “parent” of your database tables | my-database-name |
Here you can select your own database tables for custom data access. This ignores esx/qbcore framework settings for specific modules.
This allows you to have a different table for data then the default would be.
Here you can select in which table the data is located. eg okokbilling
These are the columns which are used to fetch data from the database. You can fine-grain which columns contains the required data.
The Perdon column lists the Perdon internal column names. Under Your Column you can select in which column your data is located.
These fields come from your database. The fields marked with an * are required by your table settings.
Try using https://www.yougetsignal.com/tools/open-ports/ and see if port 3306 is really open.
If this site says port 3306 is open and Perdon says it is closed, please contact support via Discord.
For windows see: https://www.opendental.com/manual/port3306.html
Make sure you restart your database after binding to your ip address!