Connecting mode for SQL
#1

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: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
Reply
#2

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.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)