SA-MP Forums Archive
MySQL Won't connect - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Server (https://sampforum.blast.hk/forumdisplay.php?fid=6)
+--- Forum: Server Support (https://sampforum.blast.hk/forumdisplay.php?fid=19)
+--- Thread: MySQL Won't connect (/showthread.php?tid=358199)


MySQL Won't connect - Swyft™ - 09.07.2012

Well I finally integrated an Admin system of MySQL into mys cript, the issue is it won't connect

On my script
pawn Код:
#define SQL_HOST "184.95.34.124" //change me
#define SQL_USER "5731_kcor" //change me
#define SQL_DB "5731_kcor" //change me
#define SQL_PASS "********" //change me
On my Volt-Host

DB Host (IP):
184.95.34.124
DB Host (Domain):
hydra.volt-host.com
DB Port:
3306
PHPMyAdmin:
hydra.volt-host.com/phpmyadmin

My MySQL Username/Database: 5731_kcor

I have tried adding the database port but I wonder if i do #define SQL_PORT "3306" or if i add it into the ip itself.

EDIT: I just tried it out, don't work

MYSQL DEBUG


[21:43:20] ---------------------------
[21:43:20] MySQL Debugging activated (07/09/12)
[21:43:20] ---------------------------
[21:43:20]
[21:43:20] >> mysql_ping( Connection handle: 0 )
[21:43:20] >> mysql_ping() - Invalid connection handle. (You set: 0, Highest connection handle ID is 0).

Re: MySQL Won't connect - donB - 09.07.2012

Quote:
Originally Posted by RockingCamman
Посмотреть сообщение
Well I finally integrated an Admin system of MySQL into mys cript, the issue is it won't connect

On my script
pawn Код:
#define SQL_HOST "184.95.34.124" //change me
#define SQL_USER "5731_kcor" //change me
#define SQL_DB "5731_kcor" //change me
#define SQL_PASS "********" //change me
On my Volt-Host

DB Host (IP):
184.95.34.124
DB Host (Domain):
hydra.volt-host.com
DB Port:
3306
PHPMyAdmin:
hydra.volt-host.com/phpmyadmin

My MySQL Username/Database: 5731_kcor

I have tried adding the database port but I wonder if i do #define SQL_PORT "3306" or if i add it into the ip itself.

EDIT: I just tried it out, don't work
Are the plugins included? What's the error you get? Btw, try using "localhost":
pawn Код:
#define SQL_HOST "localhost" //change me


Re: MySQL Won't connect - Swyft™ - 09.07.2012

Nope it did not work sadly..

I have all the plugins

Re: MySQL Won't connect - next-studio|TheKiller - 09.07.2012

Aren't you using a web server database, since the node is "hydra" ?
If yes, you need to give permission to the server ip, to access the database, on cpanel.

Re: MySQL Won't connect - Swyft™ - 09.07.2012

What?? I'm confused now haha

Re: MySQL Won't connect - Swyft™ - 10.07.2012

bump

Re: MySQL Won't connect - Swyft™ - 10.07.2012

Ooh the error i get in mys cript

C:\Users\EASYHOME\Desktop\FURIOUS DRIFTERS\gamemodes\FD.pwn(67) : warning 201: redefinition of constant/macro (symbol "mysql_fetch_row(%1)")
Pawn compiler 3.2.3664 Copyright © 1997-2006, ITB CompuPhase


1 Warning.

but on my thing it says mysql doesnt connect cause i can /register then come back on the server and it wont work

Re: MySQL Won't connect - Swyft™ - 10.07.2012

I apologize for quadrupal posting.... but I am just desperate for an answer

Re: MySQL Won't connect - Swyft™ - 10.07.2012

Another Bump