[Kruno88]

Код:

[11:13:59]  Can't connect to MySQL Database | Trying Again !
[11:14:00] Can't connect to MySQL Database | Server Closed !
.....
  > MySQL plugin unloaded.

Anyone can help me?

[Galletziz]

show your portion code where you try to connect at database.

[Kruno88]

Код:

#define SQL_HOST   "127.0.0.1"
#define SQL_USER   "root"
#define SQL_PASS   ""
#define SQL_DATA   "dayzdb"

[Sparke]

Are you sure that's your db name and such? try putting it as localhost instead of 127.0.0.1

E: Do you have PHPMyAdmin open?

[Kruno88]

Quote:

Originally Posted by Sparke Are you sure that's your db name and such? try putting it as localhost instead of 127.0.0.1 E: Do you have PHPMyAdmin open?

Doesn't work

[Galletziz]

pawn Код:

new db_connect;

//OnGameModeInit()..

db_connect = mysql_connect("localhost","root","dayzdb","");

Try this without define costants..

[Kruno88]

Quote:

Originally Posted by Galletziz pawn Код: new db_connect; //OnGameModeInit().. db_connect = mysql_connect("localhost","root","dayzdb",""); Try this without define costants..

I get 4 errors.

[Galletziz]

What errors? :\

[Kruno88]

Quote:

Originally Posted by Galletziz What errors? :\

Код:

C:\Users\Andrijana\Desktop\HDRP\gamemodes\dayzstandalone.pwn(2011) : error 010: invalid function or declaration
C:\Users\Andrijana\Desktop\HDRP\gamemodes\dayzstandalone.pwn(3484) : error 017: undefined symbol "SQL_HOST"
C:\Users\Andrijana\Desktop\HDRP\gamemodes\dayzstandalone.pwn(3492) : error 017: undefined symbol "SQL_HOST"
C:\Users\Andrijana\Desktop\HDRP\gamemodes\dayzstandalone.pwn(3896) : warning 203: symbol is never used: "db_connect"

Код:

3492:        mysql_connect(SQL_HOST, SQL_USER, SQL_DATA, SQL_PASS);
3484:     mysql_connect(SQL_HOST, SQL_USER, SQL_DATA, SQL_PASS);
203: }
2011: db_connect = mysql_connect("localhost","root","dayzdb","");

stock Connect_To_Database(){
    mysql_connect(SQL_HOST, SQL_USER, SQL_DATA, SQL_PASS);
    if(mysql_ping() == 1){
        print("[DayZ - MySQL] Connect to MySQL Database successfully !");
        return true;
	}
    else
    {
        print("[DayZ - MySQL] Can't connect to MySQL Database | Trying Again !");
        mysql_connect(SQL_HOST, SQL_USER, SQL_DATA, SQL_PASS);
        if(mysql_ping() == 1){
            print("[DayZ - MySQL] Connect to MySQL Database successfully !");
            return true;
        }
        else{
			print("[DayZ - MySQL] Can't connect to MySQL Database | Server Closed !");
            SendRconCommand("exit");
            return true;
        }
    }
}

[Kruno88]

I have no errors in Pawno but it still fails to connect to Mysql database.
I fixed those.