PDA

View Full Version : MYSQL Password using?


Sanady
08/08/2012, 04:56 PM
Hello everybody.I made today register system with StrickenKid (http://forum.sa-mp.com/showthread.php?t=122983)`s MySQL plugin.

I already defined all mySQL information in script


#define MYSQL_HOST "127.0.0.1"
#define MYSQL_USER "root"
#define MYSQL_PASS ""
#define MYSQL_DB "playerdata"


But In console is this:

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


When I register in server I can`t login with registred password.So How to disable that password??

doreto
08/08/2012, 05:01 PM
Access denied for user 'root'@'localhost' (using password: YES).

Are you sure you havent put password on your database(account)

And try to localhost insed of 127.0.0.1

Sanady
08/08/2012, 05:02 PM
Are you sure you havent put password on your database(account)

And try to localhost insed of 127.0.0.1

Where I can change password?

doreto
08/08/2012, 05:06 PM
Where I can change password?

By defout is there is no password

http://localhost/phpmyadmin/ > privileges

and it shout look like that http://i.imgur.com/RlKzh.png

Sanady
08/08/2012, 05:10 PM
By defout is there is no password

http://localhost/phpmyadmin/ > privileges

and it shout look like that http://i.imgur.com/RlKzh.png

When I type No Password and Enter into it again it`s shows me Password: bla bla

doreto
08/08/2012, 05:13 PM
scroll down and it shout be same like the picture http://i.imgur.com/dQtIF.png

Sanady
08/08/2012, 05:35 PM
scroll down and it shout be same like the picture http://i.imgur.com/dQtIF.png

There is not password how you see

http://i46.tinypic.com/20m3xc.png


Here is Server log



SA-MP Dedicated Server
----------------------
v0.3e, (C)2005-2012 SA-MP Team

[19:48:28]
[19:48:28] Server Plugins
[19:48:28] --------------
[19:48:28] Loading plugin: sscanf.dll
[19:48:28]

[19:48:28] ===============================

[19:48:28] sscanf plugin loaded.

[19:48:28] (c) 2009 Alex "******" Cole

[19:48:28] 0.3d-R2 500 Players "dnee"

[19:48:28] ===============================

[19:48:28] Loaded.
[19:48:28] Loading plugin: streamer.dll
[19:48:28]

*** Streamer Plugin v2.6.1 by Incognito loaded ***

[19:48:28] Loaded.
[19:48:28] Loading plugin: mysql.dll
[19:48:28] SA:MP MySQL Plugin v2.1.1 Loaded.
[19:48:28] Loaded.
[19:48:28] Loaded 3 plugins.

[19:48:28] [MySQL] Thread running. Threadsafe: Yes.
[19:48:28]
[19:48:28] Ban list
[19:48:28] --------
[19:48:28] Loaded: samp.ban
[19:48:28]
[19:48:28]
[19:48:28] Filterscripts
[19:48:28] ---------------
[19:48:28] Loading filterscript 'fsdebug.amx'...
[19:48:28]
*********************
* SA:MP DEBUG 0.2 *
[19:48:28] * By Simon Campbell *
*********************
[19:48:28] * Version: 0.5d *
*********************
[19:48:28] * -- LOADED *
*********************

[19:48:28] Loading filterscript 'Island.amx'...
[19:48:28]
--------------------------------------
[19:48:28] Blank Filterscript by your name here
[19:48:28] --------------------------------------

[19:48:28] Loaded 2 filterscripts.

[19:48:28] [MySQL] Error (0): Failed to connect. Access denied for user 'root'@'localhost' (using password: YES).
[19:48:28]
----------------------------------
[19:48:28] Testing man
[19:48:28] ----------------------------------

[19:48:28] Number of vehicle models: 0

doreto
08/08/2012, 05:59 PM
You have 2 users wich same name root delete this that show password - yes

Edit: if not work re-install your XAMPP you any other localhost you use

Sanady
09/08/2012, 12:20 AM
You have 2 users wich same name root delete this that show password - yes

Edit: if not work re-install your XAMPP you any other localhost you use

I Did how you says but still same problem!