SA-MP Forums Archive
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:16MySQL Debugging activated (03/08/11)
[
21:31:16] ---------------------------
[
21:31:16]  
[
21:31:16] >> mysql_connect( )
[
21:31:16CMySQLHandler::CMySQLHandler() - constructor called.
[
21:31:16CMySQLHandler::CMySQLHandler() - Connecting to "bplsy.no-ip.org" DB"zonadech" Username"masterky" ...
[
21:31:37CMySQLHandler::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? '-'