[nrg700]

Hi, I Have a VPS which I've used it as SA:MP Server Since Today. I was testing the connection between the mysql server and the SA:MP Server. The Problem is The Server doesnt add Table.

I correctly typed the Host,User Name ,Etc to fill the mysql_connect function. I even tried localhost(127.0.0.1) and The External IP as the host but no sign of working at all. Unfortunately, Both Mysql Error.log and Warning.log are empty and The Plugin seems to be loaded correctly. I've Restarted the Mysql Server for a bunch of times also Downgrade the Plugin Version into R41-2

Mysql Plugin Version : pBlueG's Mysql R41-3
Mysql Server Version : 5.7.19-0ubuntu0.16.04.1
OS : Ubuntu 16.04.1 x86

Код:

#include <a_samp>
#include <a_mysql>

new MySQL:connection;

main(){}
public OnGameModeInit()
{
	new query[50];
	connection = mysql_connect(Host,User,Pass,Data);
	mysql_format(connection,query,sizeof(query),"CREATE TABLE IF NOT EXISTS `PlayerData`(`ID` INT(10) KEY NOT NULL AUTO_INCREMENT)");
	mysql_tquery(connection,query);
	return 0;
}

public OnGameModeExit()
{
	mysql_close(connection);
	return 0;
}