MYSQL Errors - Printable Version

MYSQL Errors - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MYSQL Errors (/showthread.php?tid=592031)

MYSQL Errors - Sudaisx - 19.10.2015

I am running a gamemode which supports mysql database i need help as i am getting some errors well the error is that i entered correct mysql information but i get the error

Quote:

[MySQL] Error (0): Failed to connect. Access denied for user 'cnr'@'localhost' (using password: YES).

even tho my pass is correct and the mysql information is also correct even if i dont add a pass i get this error
my mysql_connect line:

Quote:

mysql_connect("127.0.0.1", "cnr", "cnr", "i0tykunhp7", connection, 1);

Can someone help please :/

Re: MYSQL Errors - Galhardo - 19.10.2015

Wrong password. Change it on xampp.

EDIT: Username in localhost is always "root".

Re: MYSQL Errors - Sudaisx - 19.10.2015

Still getting the same error

[MySQL] Error (0): Failed to connect. Access denied for user 'root'@'localhost' (using password: YES).

mysql_connect line:

Quote:

mysql_connect("127.0.0.1", "root", "cnr", "", connection, 1);

Tried it on wamp getting these errors :/

EDIT: I am not using pass and its showing "(using password: YES)" cant understand why :/

Re: MYSQL Errors - Galhardo - 19.10.2015

Delete then install xampp again.

Re: MYSQL Errors - Sudaisx - 19.10.2015

Quote:

Originally Posted by Galhardo

Delete then install xampp again.

If i try some other script it works and the prob is also occurring in the server which i purchased

Re: MYSQL Errors - Sudaisx - 20.10.2015

Bump!!! Anyone

Re: MYSQL Errors - Sudaisx - 20.10.2015

I contacted the host and he said

Quote:

Mysql remote works fine, you can test it with php code:

mysql_connect("my host", "my user", "mydb") or die(mysql_error());

mysql_select_db("my db") or die(mysql_error());

echo "ok";
?>

Problem is probably in myslq plugin, is too old (last update 2011).
Mysql plugin is use old mysql library with old unsupported authentication, so newer mysql servers can't accept connection.
- Zlatko Poljovka
- KGB Hosting Support

so any help?

Re: MYSQL Errors - Sudaisx - 21.10.2015

Anyone??

Re: MYSQL Errors - Sudaisx - 22.10.2015

Noone ?? :/