MYSQL Password using?
#1

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

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
Reply
#3

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

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
Reply
#5

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
Reply
#6

scroll down and it shout be same like the picture
Reply
#7

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
Reply
#8

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
Reply
#9

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!
Reply


Forum Jump:


Users browsing this thread: 2 Guest(s)