MYSQL Password using? - Printable Version

MYSQL Password using? - 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 Password using? (/showthread.php?tid=367055)

MYSQL Password using? - Sanady - 08.08.2012

Hello everybody.I made today register system with StrickenKid`s MySQL plugin.

I already defined all mySQL information in script

pawn Код:

#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??

Re: MYSQL Password using? - doreto - 08.08.2012

Quote:

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

Re: MYSQL Password using? - Sanady - 08.08.2012

Quote:

Originally Posted by doreto

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?

Re: MYSQL Password using? - doreto - 08.08.2012

Quote:

Originally Posted by Sanady

Where I can change password?

By defout is there is no password

http://localhost/phpmyadmin/ > privileges

and it shout look like that

Re: MYSQL Password using? - Sanady - 08.08.2012

Quote:

Originally Posted by doreto

By defout is there is no password

http://localhost/phpmyadmin/ > privileges

and it shout look like that

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

Re: MYSQL Password using? - doreto - 08.08.2012

scroll down and it shout be same like the picture

Re: MYSQL Password using? - Sanady - 08.08.2012

Quote:

Originally Posted by doreto

scroll down and it shout be same like the picture

There is not password how you see

Here is Server log

Код:

SA-MP Dedicated Server
----------------------
v0.3e, ©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]    © 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

Re: MYSQL Password using? - doreto - 08.08.2012

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

Re: MYSQL Password using? - Sanady - 09.08.2012

Quote:

Originally Posted by doreto

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!