[How-to] Setup FXServer with MySQL and Essentialmode4

Does this not work with Essential5? I keep getting this error message

Access denied for command add_principal.

You did not setup Essentialmode 5 correctly, follow the instructions provided in the original topic.

As a side note; Essentialmode 5 does not support MySQL.

I figured…
So it’s impossible to run Essential Mode with ESX at this moment? As ESX doesn’t support CouchDB. And Essential Mode doesn’t support MySQL.

I used to host and mod my own GMod and Rust servers and I’m a webdeveloper, so I’m not totally new to databases or LUA. But for some reason I just cant get anything but vRP to work… Seems like everyhing is incompatible with eachother at the moment, if you don’t use older versions of everything that is nearly impossible to find. Maybe I’m just stupid…

Normally I would never correct a moderator. But I’m running es5.0 and esx. Kanersps made an SQL plugin, it can be found in the es release thread.

And you never got this error? Or do you know what I’m doing wrong?

Access denied for command add_principal.

Did you do the same as in this guide, just with the newest version?

I’ve finally gotten Es4 working with MySQL. But I would rather use the newest version of course.

Thanks a lot. Seems like a fix and not something that’s intended? Is this really all that’s making it incompatible?

As far as I know. I’ve been away from fivem for awhile. Came back about a month ago. I never used es4.0. I was using es2.0 on the cfx came back to the fx server and started using es5.0 with esx.

1 Like

I have got a problem with connecting my server with database…
Im using as plugins essential, mysql-async, es_admin and esplugin_mysql…
The problem is… what i have to type into essentialmode config… to accept my mysql connection?

https://gyazo.com/ec481d8a3370e5dccb80e430496c153a

im having a problem with not being able to set my permission level through command getting error with citizen files.???idk how to fix plzz help…

hi im new to mysql im having this prob :

any idea ?

This was answered literally a few posts above yours, please read the topic and posts before replying to them.

Hello everyone i got this problem on my server
I got the newest version of everything and it loads up correctly when i press start on my server
but when i join and huge error list appears and it seemse like it wont load any of the scripts

If anyone could help me via discord or teamveiwer i would be happy, im frustrated and tired, i spend 2 days searching for fix, but i think its out of my knownledge

Thanks alot for all replies all help is a +1 from me!

here is my setup.

I have exactly the same error. idk if this was caused by a new version or something like that. Im currently trying to figure out what the problem is.
Found the problem. I needed to add sslmode=none to the connection

Version mismatch, you are currently not using the newest stable version of essentialmode. Please update
Help me

getting this erors, idk how i fix?

anyone knows any good software for mysql on ubuntu?

Can some one help please! I don’t have a password on my database so what do I do?

Will that work below?

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

Thanks.

google how to set a root password for MySQL, you need to have a password for your login information.

ah get u okay can I save the database and make a new one?