I have set up a localhost server, but when I want to join, I get the message that the multichar could not connect to the database, although it is in the server.cfg
that’s how it’s written:
set mysql_connection_string “mysql://root@localhost/esxlegacy_781fad”
Can anyone help me?
Screenshot the exact message it gives you
Anything in the server console? It should have a specific error.
not to sound redundant, but what sql software are you running is it of the “mysql” flavor like mysql or MariaDB? and i see you are using root is it set up for root and no password or how did you configure you sql server?
this is what it says in the server.cfg
but this means nothing if you don’t have mysql or simmilar database program running again what are you using for the database? mysql is a seperate program that runs the database, as it looks now you may not even have a live database to connect to
hi hi, been a few days, did we verify our database program was running?
Sorry for the late reply was on holiday
but i use mysql i also know that wall it is a localhost server for testing
Hello, make sure to have a MySQL/MariaDB server installed, you can use for example HeidiSQL to check if you can connect to the database server.
ok so mysql is running, but are you able to connect to it with a 3rd party program like (ie:HeidiSQL) using just user “root” with no password? because your asking the cfx server to connect to the database user root with no password. if you can’t connect via 3rd party look into if you have a firewall issue blocking port for the sql connection
ok i see a big issue with the info given vs the screen shot, your screenshot says your using database es_extended, however your server.cfg screen shot says your trying to use the database essentialmode these do not match perhaps decide on which database to use, if using essentialmode is what your trying to use make sure its the whole set you needed, other then this i can only assume you have firewall possibly blocking the connection but at this point its just assumptions
Yes, that’s what I came up with and switching to something else didn’t help
and the server also comes through the firewall
