SA-MP Forums Archive
mysql connection failed - 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 connection failed (/showthread.php?tid=519483)



mysql connection failed - DavidBilla - 14.06.2014

Well ,i was trying to make a mysql register system in a blank gamemode and when i try opening the samp-server.exe ,it gave out an error saying mysql connection failed. It looked exactly liked the following line

Код HTML:
[MySQL] Error (0): Failed to connect. Access denied for user 'root'@'localhost' (using password: YES).
and the mysql log reads as

Код HTML:
[Sat Jun 14 22:01:35 2014] -------------------------
[Sat Jun 14 22:01:35 2014]      Logging Started
[Sat Jun 14 22:01:35 2014] -------------------------
[Sat Jun 14 22:01:35 2014] Function: mysql_init executed with result: "0".
[Sat Jun 14 22:01:35 2014] Error (0): Failed to connect. Access denied for user 'root'@'localhost' (using password: YES).
[Sat Jun 14 22:01:50 2014] Error (0): Function: mysql_close called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
[Sat Jun 14 22:01:50 2014] -------------------------
[Sat Jun 14 22:01:50 2014]       Logging Ended
[Sat Jun 14 22:01:50 2014] -------------------------
for more info
I'm using strickenkid's mysql plugin and xampp to create database...
i don't know what i'm doing wrong,since im completely new to mysql.

i used hostname as "127.0.0.1" , Username "root" , Password "" , database "server".

hope someone could help me out...


Re: mysql connection failed - iZN - 14.06.2014

Use hostname 'localhost' that should solve it and are you sure about the password?


Re: mysql connection failed - DavidBilla - 14.06.2014

Quote:
Originally Posted by iZN
Посмотреть сообщение
Use hostname 'localhost' that should solve it and are you sure about the password?
Well i changed the name to localhost but still the problem occurs,i'm not really sure what my default password is or how i could change it...


Re: mysql connection failed - Inn0cent - 14.06.2014

You are sure, that your mysql is running.


Re: mysql connection failed - DavidBilla - 15.06.2014

still having the issue ,hope someone could help me...


Re: mysql connection failed - DavidBilla - 15.06.2014

Help please...


Re: mysql connection failed - DavidBilla - 15.06.2014

Bump