[Help] LARP MySQL Error
#1

Hello, every time i connect to server it restarts and logs are:
Код:
[00:48:18] MYSQL: MySQL Player Accounts v0.1 by Luk0r
[00:48:18] MYSQL: Adaptado y actualizado por bruunosoniico
[00:48:18] MYSQL: Attempting to connect to server...
[00:48:18] MYSQL: Database connection established.
[00:48:18] Number of vehicle models: 86
[00:48:42] Incoming connection: 127.0.0.1:56807
[00:48:42] [join] Stan_Minton has joined the server (0:127.0.0.1)
[00:48:42] MYSQL: Connection seems dead, retrying...
[00:48:42] MYSQL: Could not reconnect to server, terminating server...
[00:48:42] --- Server Shutting Down.
[00:48:42] [part] Stan_Minton has left the server (0:0)
Reply
#2

The details you used on mysql_connect are most likely incorrect, verify them.
Either that or the MySQL server isn't on.
Reply
#3

I'm not so dumb, the details are correct, I checked it like hundred times... And MySQL server is definately on, because I talked all day to my server host provider.
Reply
#4

Have you granted your server's IP access to the database?

GRANT ALL ON 'user'@'host' TO 'db' IDENTIFIED BY 'pass'
Reply
#5

YES.
Reply
#6

So obviously your firewall is blocking the connection.

That's the only possible explanation short of a corrupt installation
Reply
#7

How is it possible for firewall to block in Virtual Private Server?
Reply
#8

Post your MySQL configuration (omit usernames/passwords obviously)
Reply
#9

Код:
#define MYSQL_HOST "82.135.154.4"
#define MYSQL_USER "usr125"
#define MYSQL_PASS "87622"
#define MYSQL_DB   "usr125_db"
Reply
#10

...remove your username and password!? Do you want someone to hack your shit?

Change MYSQL_HOST to "localhost" or "127.0.0.1" if you are hosting the MySQL server on your VPS (I assumed from your description that you have set it up this way)
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)