2 server machine 1 fxserver 1 sql how to connect to it?

FiveM Server Development Server Discussion
1

2 server buy ovh.com and 1
server machine: esx szerver and
another server 2.: database Mysql,
not connect to database :frowning: how to fix?
password is correct!
server.cfg:
set mysql_connection_string “server=XX.XX.XX.XXX;database=szerver;userid=root;password=123445d

de
de929×414 127 KB

2

Are both machine able to ping each other?

3

yes connect

4

Have you check your firewall?

5

no firewall on

6

Ensure your MySQL database has remote connection allowed. It’s often disabled for security reasons.

7

yes enabled.

8

You can’t and shouldn’t utilize ROOT for this, as if ROOT is enabled to be connected from anywhere, then ROOT is able to do anything within the database unrestricted and potentially hazardous incl. all data lost with 1 command from any location anywhere. It would be automatically bruteforced within days by global botnets etc.

You need to make a different user for external connections, and then go enable it for the IP(s) you are trying to connect from. If you then set the new user to 0.0.0.0 you can enable all on the new account.