txAdmin does this automatically already but if needed then in your server.cfg put this and fill it in with the correct information. For the database wrapper oxmysql
You can change the configuration settings by using convars inside your server.cfg. Reference the following for an idea of how to set your connection options. You must include one of the following lines, adjusted for your connection and database settings.
Copy
set mysql_slow_query_warning 150set mysql_debug true
Certain special characters are reserved or blocked and may cause issues when used in your password.
For more optional settings (such as multiple statements) you can reference pool.d.ts and connection.d.ts.You can also add the following convars if you require extra information when testing queries.
Copy
set mysql_slow_query_warning 150set mysql_debug true
Setting up your server.cfg is really simple and is already completed upon a successful txAdmin recipe install! You can also find additional information on server configuration files here. In case of a manual install then here’s a template to use
Copy
## server main settings{{serverEndpoints}}sv_maxclients {{maxClients}}set gamename rdr3set sv_enforceGameBuild 1491# https://docs.fivem.net/docs/server-manual/server-commands/#sv_purelevel-level#sets sv_pureLevel 1#sets sv_pureLevel 2# locale configsetr rsg_locale "en"setr ox:locale en## key license settingssv_licenseKey "{{svLicense}}"set steam_webApiKey "none"## database settingsset mysql_connection_string "{{dbConnectionString}}"set mysql_slow_query_warning 300## server settingssv_hostname "{{serverName}} built with {{recipeName}} by {{recipeAuthor}}!"sets sv_projectName "[{{recipeName}}] {{serverName}}"sets sv_projectDesc "{{recipeDescription}}"sets locale "en-US"load_server_icon myLogo.pngsets Framework "RSG"sets Framework Discord "https://discord.gg/eW3ADkf4Af"sets banner_detail "link"sets banner_connecting "link"sets Discord "link"sets Developer "link"sets tags "rsg,roleplay"sv_endpointprivacy trueset txAdmin-menuPtfxDisable true # Disable TXAdmin NoClip Particle Effectset sv_experimentalNetGameEventHandler false# https://v6.mantine.dev/theming/colors/#default-colorssetr ox:primaryColor redsetr ox:primaryShade 8# use targetsetr UseTarget false# default resourcesensure mapmanagerensure spawnmanagerensure sessionmanager-rdr3#ensure basic-gamemode#ensure hardcap# database and libraryensure oxmysqlensure ox_lib# resourcesensure rsg-coreensure rsg-multicharacterensure rsg-spawnensure rsg-menubaseensure ox_targetensure ip-chatensure [standalone]ensure [framework]ensure [mapmods]## weathersync permissionsexec resources/[standalone]/weathersync/permissions.cfg## Permissions ##add_ace group.admin command allow # allow all commandsadd_principal identifier.license:xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx rsgcore.god # << your rockstar licenceadd_principal identifier.license:xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx group.admin # << your rockstar licence# Resourcesadd_ace resource.rsg-core command allow # Allow rsg-core to execute commands# Godsadd_ace rsgcore.god command allow # Allow all commands# Inheritanceadd_principal rsgcore.god group.admin # Allow gods access to the main admin group used to get all default permissionsadd_principal rsgcore.god rsgcore.admin # Allow gods access to admin commandsadd_principal rsgcore.admin rsgcore.mod # Allow admins access to mod commands