[Mowgli]

I cannot connect to the Mysql server on this script, i have entered the data im sure...

Code:

#define MYSQL_HOST "sql110.byethost31.com "
#define MYSQL_USER "b31_4369867"
#define MYSQL_PASS "notforyou"
#define MYSQL_DB  "b31_4369867_modern"

This is the error:

Code:

[19:54:11] MYSQL: Attempting to connect to server...
[19:54:11] 
Connection to MySQL database: Failed !
[19:54:11] Unknown MySQL server host 'sql110.byethost31.com ' (11004)

[19:54:11] Error in mysql_select_db: MySQL server has gone away
[19:54:11] MYSQL: Connection error, retrying...
[19:54:11] 
Connection to MySQL database: Failed !
[19:54:11] Unknown MySQL server host 'sql110.byethost31.com ' (11004)

[19:54:11] Error in mysql_select_db: MySQL server has gone away
[19:54:11] MYSQL: Could not reconnect to server, terminating server...
[19:54:11] --- Server Shutting Down.
[19:54:11] 
/***************************************************/
/* SAMP-MySQL v0.15 Plugin unloaded successfully ! */
/***************************************************/

[Fj0rtizFredde]

Maybe itґs because the space in MYSQL_HOST? I did have a problem like this before and it was because I did have a space at the and in MYSQL_HOST

[Mowgli]

still dont work when i remove it

[Silent314]

Nothing appears to exist at "sql110.byethost31.com"...

[Mowgli]

thats defently my sql host, ill get screenie

[shady91]

have you made so your Database allows your Server IP to connect as i have to allow an IP to connect to my database before it will connect, if you cant get your data base sorted, pm me and ill make you a MySQL data base allow your IP to connect and you can do what ever from there.

[Silent314]

That probably is the issue. If your host is hosting the MySQL database from an external source/different IP address, you need to make sure the server IP is allowed to contact the database.

[Woet]

Oh, and hosting MySQL remotely will lag your server immensely.

[Ronaldo_raul™]

facing the same problem..i can't just connect to my database i am also using byethost...! Any please help us.!