[HELP] How to connect a MySQL database with MySQL Async

FiveM Resource Development & Modding Discussion
1

I have tried the MySQL async connection string thing. Where one the server.cfg does it go? I’ve Tried it under convars I’ve tried it above everything. I Just don’t get it.

2 Likes
2

@Lucas_Decker exapmle:

you probably don’t want to change these!

only change them if you’re using a server with multiple network interfaces

endpoint_add_tcp “0.0.0.0:30120”
endpoint_add_udp “0.0.0.0:30120”

set es_enableCustomData 1
set mysql_connection_string “server=127.0.0.01;database=essentialmode;userid=root;”

start mapmanager

4 Likes
3

You can put it anywhere in server.cfg, it shouldn’t matter.

1 Like
4

To everyone having problem with this:

The right string is this one:

set es_enableCustomData 1
set mysql_connection_string “server=127.0.0.1;database=essentialmode;userid=root;”

(albin-32 wrote 127.0.0.01 instead of 127.0.0.1)

3 Likes
5

where to write the password of database

6

set mysql_connection_string “server=[SERVERNAME];database=[DBNAME];userid=[USERNAME];password=[PASSWORD]”