MySQL (EssentialMode)

FiveM Client Support
1

Hello !
After a long time i finally succesfully installed MySQL.
But an error is coming up ;

2017-04-12 16:25:35.6792|ERROR|CitizenMP.Server|Error creating script environment for resource essentialmode: Unable to connect to any of the specified MySQL hosts.
2017-04-12 16:25:35.6816|ERROR|CitizenMP.Server| at [U] MySql.Data.MySqlClient.NativeDriver.Open()
2017-04-12 16:25:35.6816|ERROR|CitizenMP.Server| at [U] MySql.Data.MySqlClient.Driver.Open()
2017-04-12 16:25:35.6816|ERROR|CitizenMP.Server| at [U] MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)

Can someone help me please ?
Thank’s.
Red

2

UP
Noone has this problem ?
A solution ?

3

Do you have a VPS or something where you put your server ?

4

Yeah, i have a VPS who i put my server

5

I had the same problem i found the solution 1h ago it took me 1 day to solv it
Do you use FileZilla ?

6

Yes i use FileZilla !

7

Perfect i have the solution for you,
You need to install MySQL server in your VPS so in FileZilla
But you need to use putty, do you have putty ?

8

Good to hear !
Yes i have Putty

9

And i installed MySQL Server on my VPS.

10

You did just now are before you created the topic ?

11

Yeah i did it before creating this topic

12

Okay did you install the sql.sql in your MySQL ? It is in the essential folder ?

13

I imported the “sql.sql” file in MySQL, but it is not in the essentialmode folder.

14

It’s not a problem if you import it did you touch to the login.lua in this folder ? “bin/resources/essentialmode/server/player”

15

Yeah i put all the correct informations in there.

16

Did you touch to the IP ?

17

Yeah, i putted the ip from my VPS

18

So it is not 127.0.0.1 ?

19

Yeah, it’s not 127.0.0.1

20

You need to put it because you install the MySQL on the VPS so its a localhost, so just put this IP 127.0.0.1 in “bin/resources/essentialmode/server/player” in the login.lua file and the password if you didn’t put it