Hi, I have a VPS server for FiveM, and it works fine until I get to the mySQL section. It’s a ubuntu terminal only, no UI. I’ve made an sql on the VPS, and one of the databases it has is the one I made, fivem_server.
How do I then import the extended essentials database into that SQL? I’ve tried connecting to it every which way with HeidiSQL, but no luck. Hopefully someone can help!
I’m happy to connect over discord or otherwise if doing a voice chat makes things easier
Just create new account with all privileges to your database ex. call it server
Do this in mysql terminal:
CREATE USER ‘server’@’%’ IDENTIFIED BY ‘password’;
This thing “%” makes u can connect to this account from non specified ip.
If you want do only server can connect to account server do this:
CREATE USER ‘server’@‘serverip’ IDENTIFIED BY ‘password’;
After that do this
GRANT ALL ON mydb.* TO ‘server’@’%’; - FOR ALL IP’S
GRANT ALL ON mydb.* to ‘server’@‘serverip’; - FOR ONLY SERVER
mydb = Your database name