Wtf? Can't connect to MySQL. - Printable Version

Wtf? Can't connect to MySQL. - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Server (https://sampforum.blast.hk/forumdisplay.php?fid=6)
+--- Forum: Server Support (https://sampforum.blast.hk/forumdisplay.php?fid=19)
+--- Thread: Wtf? Can't connect to MySQL. (/showthread.php?tid=578351)

Wtf? Can't connect to MySQL. - Shady - 18.06.2015

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

Re: Wtf? Can't connect to MySQL. - Sergei - 18.06.2015

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

Re: Wtf? Can't connect to MySQL. - Shady - 18.06.2015

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

Re: Wtf? Can't connect to MySQL. - AndySedeyn - 18.06.2015

Check the permissions of your database user.

Re: Wtf? Can't connect to MySQL. - Shady - 18.06.2015

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

Re: Wtf? Can't connect to MySQL. - AndySedeyn - 18.06.2015

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

Re: Wtf? Can't connect to MySQL. - Shady - 18.06.2015

Yeah

pawn Код:

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

Re: Wtf? Can't connect to MySQL. - AndySedeyn - 18.06.2015

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

Re: Wtf? Can't connect to MySQL. - Shady - 18.06.2015

yeah

Re: Wtf? Can't connect to MySQL. - Jimmy0wns - 18.06.2015

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.

Re: Wtf? Can't connect to MySQL. - Shady - 18.06.2015

How to remove the password? I have XAMPP.

Re: Wtf? Can't connect to MySQL. - Phaze - 18.06.2015

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.

Re: Wtf? Can't connect to MySQL. - Shady - 18.06.2015

Doesn't work, problem is from?

Re: Wtf? Can't connect to MySQL. - Rancho - 18.06.2015

It looks you are typing wrong password.

Re: Wtf? Can't connect to MySQL. - Shady - 19.06.2015

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

Re: Wtf? Can't connect to MySQL. - MustangV10 - 20.06.2015

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.