[MindaugasL]

Hello guys.I have problem,when my GameMode connecting to mysql.When it try to connect,I get this:

PHP код:

[20:15:05] >> mysql_connect( )
[20:15:05] CMySQLHandler::CMySQLHandler() - constructor called.
[20:15:05] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "samp15385" | Username: "samp15385" ...
[20:15:05] CMySQLHandler::Connect() - Access denied for user 'samp15385'@'localhost' (using password: YES) (Error ID: 1045) 


GameMode mysql code:

PHP код:

public OnGameModeInit()
{
    mysql_debug( true );
    mysql_connect(MySQL_HOST,MySQL_USER,MySQL_DATA,MySQL_PASS);
    if( mysql_ping( ) >= 1 )
    {
        print( "Connected to mysql succsesfull" );
    }
    else
    {
        print( "Connected to mysql failed" );
    }
    for(new p=0; p<MAX_STREAMED_OBJECT; p++)
    {
        myobject[p] = -1;
    } 


PHP код:

#define MySQL_HOST "127.0.0.1"
#define MySQL_USER "samp2514"
#define MySQL_DATA "samp2514"
#define MySQL_PASS "karoce" 


Can say to me whats wrong?

[gtakillerIV]

Are you sure that your MySQL username and password are correct? You might wanna try "root" as username and without a password(leave the password empty "").

[MindaugasL]

Quote:

Originally Posted by gtakillerIV Are you sure that your MySQL username and password are correct? You might wanna try "root" as username and without a password(leave the password empty "").

Yes,it correct.I have a samp server host,maybe my gamemode needs VPS?

[Konstantinos]

Quote:

Originally Posted by MindaugasL Yes,it correct.I have a samp server host,maybe my gamemode needs VPS?

If you're on a host, use their details.

[MindaugasL]

Quote:

Originally Posted by Konstantinos If you're on a host, use their details.

I using their detail's,but it same problem :/ Can u help me?

[Konstantinos]

Quote:

Originally Posted by MindaugasL I using their detail's,but it same problem :/ Can u help me?

No, you're not. I can see "127.0.0.1" (which is localhost) as the host while it should be an IP (of the host or some dns name).

[DanishHaq]

Drop your host a ticket and ask them whether or not the IP of the MySQL database will be called locally in regards to your server IP, because sometimes they put the SQL database on the same server as your current IP too, if that's the case then you use "localhost" as your host. Otherwise, you need to change that as said above in Konstantinos' post.

[iJumbo]

And you have already tryed to use your server ip instead of localhost one?