[Shady]

Hello,

When I starting the server on the VPS, It's giving me that access denied, How to solve it?

mysql_log.txt:

pawn Код:

[Thu Jun 18 12:50:26 2015] -------------------------
[Thu Jun 18 12:50:26 2015]      Logging Started
[Thu Jun 18 12:50:26 2015] -------------------------
[Thu Jun 18 12:50:27 2015] Error (0): Failed to connect. Access denied for user 'gto'@'WIN-ETGQQT9LA10' (using password: YES).

[Sergei]

Doesn't log tell you enough? You got wrong user and password combination.

[Shady]

I don't have anything wrong.

pawn Код:

[12:18:27] [MySQL] Error (0): Failed to connect. Access denied for user 'gto'@'WIN-ETGQQT9LA10' (using password: YES).

[AndySedeyn]

Check the permissions of your database user.

[Shady]

Check the screen and tell me If there is something wrong.

[AndySedeyn]

Are you sure that you're entering the correct credentials?

[Shady]

Yeah

pawn Код:

mysql_connect("localhost", "gto", "gto", "passwordhere", connection, 1);

[AndySedeyn]

That's not what I meant. Is the password you filled in correct?

[Shady]

yeah

[Jimmy0wns]

Try removing the password temporarily, if that doesn't work, then it's not allowing you to login, some hosts block incoming connections from unknown IPs.

[Shady]

How to remove the password? I have XAMPP.

[Phaze]

HOST=127.0.0.1

Use that instead of localhost, it's the same thing but it happened to me once and I put that instead of localhost and it fixed for some odd reason.

[Shady]

Doesn't work, problem is from?

[Rancho]

It looks you are typing wrong password.

[Shady]

I do not have a password on MySQL DB, Maybe script is bugged?

[MustangV10]

Have you tried connecting to the user manually?

You can do so with:

mysql -u gto -p

By running the above, as root, you should be prompted to enter the password for the 'gto' user.