[Abreezy]

Howdy,

I've been scripting with MySQL for about a month, give or take, and all of a sudden, it won't connect to anything I direct it to. It gives the following messages:

Код:

[Mon Sep 05 16:00:04 2011] -------------------------
[Mon Sep 05 16:00:04 2011]      Logging Started
[Mon Sep 05 16:00:04 2011] -------------------------
[Mon Sep 05 16:00:04 2011] Function: mysql_init executed with result: "0".
[Mon Sep 05 16:00:05 2011] Error (0): Failed to connect. Access denied for user '1793_larp '@'ool-18928872.dyn.optonline.net' (using password: YES).
[Mon Sep 05 16:00:05 2011] Error (0): Function: mysql_query called when not connected to any database. Access denied for user '1793_larp '@'ool-18928872.dyn.optonline.net' (using password: YES).
[Mon Sep 05 16:00:05 2011] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user '1793_larp '@'ool-18928872.dyn.optonline.net' (using password: YES).
[Mon Sep 05 16:00:05 2011] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user '1793_larp '@'ool-18928872.dyn.optonline.net' (using password: YES).

I have the correct MySQL connection which is:

pawn Код:

//==============================================================================
// SQL Configuration
//==============================================================================
#define SQL_HOST                                                                "91.204.210.26"
#define SQL_USER                                                                "1793_larp "
#define SQL_PASS                                                                "***hidden***"
#define SQL_DATA                                                                "1793_larp "

Blocked the password for obvious reasons. The connection for MySQL is:

pawn Код:

public OnGameModeInit()
{
    //==========================================================================
    // - Initial Loadup
    //==========================================================================
    ConnectToMySQL();   // Connect to MySQL

The ConnectToMySQL:

pawn Код:

ConnectToMySQL()
{
    new MySQL:connection = mysql_init(LOG_ALL, 1);
    mysql_connect(SQL_HOST, SQL_USER, SQL_PASS, SQL_DATA, connection, 1);
    return 1;
}

Anyone see an error, or reason for failure to connect? Thanks in advance for all comments/help.

[JaTochNietDan]

Are you sure the MySQL server allows remote connections?

[Abreezy]

I've ran it from Volt-Host aswell and get the same errors:

pawn Код:

[17:30:35] [MySQL] Error (0): Failed to connect. Access denied for user '1793_larp '@'orion.volt-host.com' (using password: YES).
[17:30:35] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user '1793_larp '@'orion.volt-host.com' (using password: YES).
[17:30:35] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user '1793_larp '@'orion.volt-host.com' (using password: YES).
[17:30:35] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user '1793_larp '@'orion.volt-host.com' (using password: YES).