[Sascha]

Hi, I'm using:

pawn Code:

new MySQL:connection = mysql_init(LOG_ONLY_ERRORS, 1);
    mysql_connect("208.115.247.247", "sgtadmin_hsabot@sgt-site.tk", "password", "sgtadmin_hsaserver", 1, connection);

however I get:
(160) : warning 213: tag mismatch
(160) : warning 213: tag mismatch

(at mysql_connect line)

[Anthonyx3']

An easier way to do it is to define the user, pass, ip, database.

pawn Code:

new MySQL:connection = mysql_init(LOG_ONLY_ERRORS);
    mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_PASS, MYSQL_DB, connection, 1);

Then you could define those like this:

pawn Code:

#define MYSQL_HOST  ""
#define MYSQL_USER  ""
#define MYSQL_DB    ""
#define MYSQL_PASS  ""

[Sascha]

I know, however that doesn't answer why those warnings show up / how to fix it, as it is exactly how the wiki tut of it says...

[Typhome]

mysql_connect("208.115.247.247", "sgtadmin_hsabot@sgt-site.tk", "password", "sgtadmin_hsaserver", 1, connection);

to

mysql_connect("208.115.247.247", "sgtadmin_hsabot@sgt-site.tk", "password", "sgtadmin_hsaserver", connection, 1);

[Anthonyx3']

Quote:

Originally Posted by Sascha I know, however that doesn't answer why those warnings show up / how to fix it, as it is exactly how the wiki tut of it says...

You didnt check my code, like above poster said change those 2 around

[Sascha]

that's true anthon...
I focused my reading on the #define advice lol -.- sry

[Sascha]

but now I have this problem:
Error (0): Failed to connect. Access denied for user 'sgtadmin_hsabot@sgt-site.tk'@'lizard.serverffs.com' (using password: YES).

how to get rid of the @lizard.serverffs.com?

[Think]

Quote:

Originally Posted by Sascha but now I have this problem: Error (0): Failed to connect. Access denied for user 'sgtadmin_hsabot@sgt-site.tk'@'lizard.serverffs.com' (using password: YES). how to get rid of the @lizard.serverffs.com?

its the dns the ip is set to, you cant unless you connect to an other mysql server. so change the ip.