[Help][Mysql]Connecting to Mysql from the script.. - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: [Help][Mysql]Connecting to Mysql from the script.. (/showthread.php?tid=108188)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: [Help][Mysql]Connecting to Mysql from the script.. (/showthread.php?tid=108188)
[Help][Mysql]Connecting to Mysql from the script.. - Mowgli - 12.11.2009
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"
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 ! */ /***************************************************/
Re: [Help][Mysql]Connecting to Mysql from the script.. - Fj0rtizFredde - 12.11.2009
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
Re: [Help][Mysql]Connecting to Mysql from the script.. - Mowgli - 12.11.2009
still dont work when i remove it
Re: [Help][Mysql]Connecting to Mysql from the script.. - Silent314 - 12.11.2009
Nothing appears to exist at "sql110.byethost31.com"...
Re: [Help][Mysql]Connecting to Mysql from the script.. - Mowgli - 12.11.2009
thats defently my sql host, ill get screenie
Re: [Help][Mysql]Connecting to Mysql from the script.. - shady91 - 12.11.2009
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.
Re: [Help][Mysql]Connecting to Mysql from the script.. - Silent314 - 12.11.2009
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.
Re: [Help][Mysql]Connecting to Mysql from the script.. - Woet - 12.11.2009
Oh, and hosting MySQL remotely will lag your server immensely.
Re: [Help][Mysql]Connecting to Mysql from the script.. - Ronaldo_raul™ - 24.07.2011
facing the same problem..i can't just connect to my database i am also using byethost...! Any please help us.!