MYSQL Connection? - 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: MYSQL Connection? (
/showthread.php?tid=237127)
MYSQL Connection? -
MasterKy - 09.03.2011
Hellow! I am trying to connect for my DB but it don't works. The MYSQL is online, i do login at the phpMyAdmin have not problem.
When i open my server, the mysql dont connect, anyone can help? Very tnx for all answers!
Debug:
PHP код:
[21:31:16]
[21:31:16] ---------------------------
[21:31:16] MySQL Debugging activated (03/08/11)
[21:31:16] ---------------------------
[21:31:16]
[21:31:16] >> mysql_connect( )
[21:31:16] CMySQLHandler::CMySQLHandler() - constructor called.
[21:31:16] CMySQLHandler::CMySQLHandler() - Connecting to "bplsy.no-ip.org" | DB: "zonadech" | Username: "masterky" ...
[21:31:37] CMySQLHandler::Connect() - Can't connect to MySQL server on 'sql.zonadechat.t5.com.br' (10060) (Error ID: 2003)
[21:31:37] >> mysql_ping( Connection handle: 1 )
[21:31:37] CMySQLHandler::Ping() - You cannot call this function now. (Reason: Dead Connection)
[21:31:37] >> mysql_connect( )
[21:31:37] CMySQLHandler::CMySQLHandler() - constructor called.
[21:31:37] CMySQLHandler::CMySQLHandler() - Connecting to "sql.zonadechat.t5.com.br" | DB: "zonadech" | Username: "zonadech" ...
[21:31:42] CMySQLHandler::Connect() - Connection was successful.
[21:31:42] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.
[21:31:42] >> mysql_ping( Connection handle: 1 )
[21:31:42] CMySQLHandler::Ping() - You cannot call this function now. (Reason: Dead Connection)
[23:11:45] >> mysql_ping( Connection handle: 1 )
[23:11:45] CMySQLHandler::Ping() - You cannot call this function now. (Reason: Dead Connection)
Re: MYSQL Connection? -
[WF]Demon - 09.03.2011
Is the DataBase on the same ip as your server? if so connect to the db with ip 127.0.0.1.
Re: MYSQL Connection? -
MasterKy - 09.03.2011
Bah =s so I'll only be able to connect to the server that is on the same IP? Do haven't another mean to connect to a external DB?
Re: MYSQL Connection? -
MasterKy - 09.03.2011
Thanx for the help so far!
someone know how to? '-'