Mysql connect - Printable Version

Mysql connect - 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)
+--- Thread: Mysql connect (/showthread.php?tid=325141)

Mysql connect - Tanush123 - 12.03.2012

Well i never tryed localhost but today i tried to but the problem is when i make a random username and connect, it doesn't asks me to register. Also when i try to create any org, it says the id is used. This is my debug mysql

Код:

00:16:55]  

[00:16:55] ---------------------------

[00:16:55] MySQL Debugging activated (03/12/12)

[00:16:55] ---------------------------

[00:16:55]  

[00:16:55] >> mysql_query( Connection handle: 1 )

[00:16:55] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[00:16:55] >> mysql_store_result( Connection handle: 1 )

[00:16:55] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[00:16:55] >> mysql_num_rows( Connection handle: 1 )

my connection for script

pawn Код:

#define MYSQL_HOST  "localhost"
#define MYSQL_USER  "localhost"
#define MYSQL_DB    "accounts"
#define MYSQL_PASS  ""

I used Xampp for http://localhost/phpmyadmin

Re : Mysql connect - vernz - 12.03.2012

Mysql user should be root, not localhost

Re: Mysql connect - Tanush123 - 12.03.2012

Ah Thank you, repped.

Re: Mysql connect - DarkScripter - 12.03.2012

Try:

pawn Код:

#define MYSQL_HOST  "localhost"
#define MYSQL_USER  "root"
#define MYSQL_DB    "accounts"
#define MYSQL_PASS  ""

Re : Mysql connect - vernz - 12.03.2012

Your welcome.

Dark, you don't need to repeat the same thing as me, he said ah thank you it means he already fixed it.

Re: Re : Mysql connect - DarkScripter - 12.03.2012

Quote:

Originally Posted by vernz

Your welcome.

Dark, you don't need to repeat the same thing as me, he said ah thank you it means he already fixed it.

yep,
i reply after Vernz, Sorry.

Re : Mysql connect - vernz - 12.03.2012

Oh okay my bad, no problem.