[Help]1045 - Access denied for user 'root'@'localhost' (using password: YES)

01/08/2012 05:39 matrix89#1
need help..How to fix this?
[Only registered and activated users can see links. Click Here To Register...]
01/08/2012 05:41 .FailMorePls##2
Do you use the false password
01/08/2012 05:52 matrix89#3
no..
default user and password..
username : root
password : test

how to fix it?..you know?
01/08/2012 05:55 .FailMorePls##4
I only know from the game metin2 when this error comming you use the false password ..

maybe you use caps lock or ?
01/08/2012 07:08 XxFearReaperXx#5
its not allowing
user: root
Pass: test
into navicat
try going around it with
User: ODBC
Pass: (LEAVE BLANK)
also try
User:test
Pass:test
those are the most common exploits into gaining database access
lemme know if it works
01/08/2012 11:19 Jack Sparrow#6
Check your datebase config files the passwords should be there .
also do as fear said because not all datebases use the same login and pass
also try
test
root
last time i was on tv with somone this worked .
01/09/2012 18:55 PowerChaos#7
depends what version you took and from where are those the passwords that are used

root / test
test / test
root / rufeng
root /

yes , you saw it good , last username does not contain a password

if those things fails , please download my easy website package and login as root/test or just root (not sure anymore what pass it was)

Greetings From PowerChaos
01/10/2012 20:19 idlemonkey#8
if you open mysql my admin yknow the little green light in the corner and look in var data it will tell you its password..... but you should look in your users because if you dont have the privileges to access the db even if you have a password it wont connect
01/10/2012 21:11 acekill#9
this happend to me once upon a time and i just basically made my connection name for navicat localhost which is the default name and i proceeded to put in the password, it was a simple answer, but it worked for me
01/12/2012 19:20 PowerChaos#10
well basicly the error says it all

lets split it up to easy understand it

Quote:
Originally Posted by error
Access denied for user 'root'@'localhost' (using password: YES)
so first acces is denied

it is for user "root"
that try to make a connection to "localhost" (also called 127.0.01 )
and it use a password (using password : yes)

so to fix it
check the 3 variables

is the user "root" allowed to conect to localhost with the provided password ??
is localhost the right place to connect (from a webserver to vps != localhost )
is the passwor right ?? ( Test != test )

so to fix it , check above variables and change as needed
if "localhost" failt , try to use "127.0.0.1" (is localhost to)
or if "127.0.0.1" then use "localhost" as it sometimes does not work on ip

for the rest , you definaly used a wrong value

no other thing can fix that error , so a long explanation of a easy error :D

Greetings From PowerChaos
05/05/2013 16:47 .Horny#11
mysql nicht installiert /online oder hat keine rechte!
05/19/2013 19:11 Kalrasha#12
Make sure Wamp is on.
For Windows 7+ nt after running wamp