MySQL (EssentialMode)

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 ?

Noone has this problem ?
A solution ?

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

Yeah, i have a VPS who i put my server

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

Yes i use FileZilla !

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 ?

Good to hear !
Yes i have Putty

And i installed MySQL Server on my VPS.

You did just now are before you created the topic ?

Yeah i did it before creating this topic

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

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

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

Yeah i put all the correct informations in there.

Did you touch to the IP ?

Yeah, i putted the ip from my VPS

So it is not ?

Yeah, it’s not

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