Connecting mode for SQL - Printable Version

Connecting mode for SQL - 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: Connecting mode for SQL (/showthread.php?tid=657333)

Connecting mode for SQL - OfekEfron - 05.08.2018

Hey its my first time using SQL and i need help with it:

Quote:

#define MYSQL_HOSTNAME "144.***.248.***" // PLUX.
#define MYSQL_DATABASE "communit_samp"
#define MYSQL_USERNAME "communit_samp"
#define MYSQL_PASSWORD "***"

i have filled this up with the information

Quote:

connectionID = mysql_connect(MYSQL_HOSTNAME, MYSQL_USERNAME, MYSQL_DATABASE, MYSQL_PASSWORD);

if(mysql_errno(connectionID))
{
print("[ERROR] - Unable to establish a connection with the MySQL server...");
SendRconCommand("exit");
return 0;
}

radioConnectionID = mysql_connect(MYSQL_HOSTNAME, MYSQL_USERNAME, "shoutcast", MYSQL_PASSWORD);

if(mysql_errno(radioConnectionID))
{
print("[WARNING] - Couldn't connect to radio station database... server will continue to operate normally.");
radioConnectionID = 0;
}

this what i got in the OnGameModeInit, now when i start the server its always saying: [ERROR] - Unable to establish a connection with the MySQL server...

This is the errors:

Quote:

[18:15:37] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[18:15:38] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'communit_samp'@'bzq-79-178-79-64.red.bezeqint.net' (using password: YES)
[18:15:38] [WARNING] CMySQLConnection:

isconnect - no connection available
[18:15:38] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'communit_samp'@'bzq-79-178-79-64.red.bezeqint.net' (using password: YES)
[18:15:38] [WARNING] CMySQLConnection:

isconnect - no connection available
[18:15:39] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[18:15:39] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[18:15:39] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)

if someone know that i need to do to get this work please help me

Re: Connecting mode for SQL - GTLS - 05.08.2018

There is some problem with Username - Password Combination. Either you are entering a wrong Username or you are entering a wrong password.

Another possibility is that, you dont have MySQL Server running. I'd say install XAMPP and run the SQL and Apache Services.