Page 1 of 1

#1045 - Access denied for user 'root'@'localhost'

Posted: Sat Mar 07, 2009 12:26 am
by senthil babu
Hi..

when i download wamp server, it shows this error for mysql
"#1045 - Access denied for user 'root'@'localhost' (using password: NO)"
how can i solve this.. say clearly

see u again
:)

Re: #1045 - Access denied for user 'root'@'localhost'

Posted: Sat Mar 07, 2009 12:38 am
by susrisha
that means the password that it got is wrong

Re: #1045 - Access denied for user 'root'@'localhost'

Posted: Sat Mar 07, 2009 1:14 am
by requinix
susrisha wrote:that means the password that it got is wrong
Or that the password it didn't get is wrong.
(using password: NO)
Provide a password.

Re: #1045 - Access denied for user 'root'@'localhost'

Posted: Sat Mar 07, 2009 2:23 am
by BomBas
Of course it didn't get a password, WAMP isn't using a password.

Re: #1045 - Access denied for user 'root'@'localhost'

Posted: Sat Mar 07, 2009 2:36 am
by requinix
BomBas wrote:Of course it didn't get a password, WAMP isn't using password.
Then any ideas why root, a user which certainly does exist, can't log on without a password?

Re: #1045 - Access denied for user 'root'@'localhost'

Posted: Sat Mar 07, 2009 3:15 am
by BomBas
Try to login into PHPMYADMIN without a password.

Does it work?

Re: #1045 - Access denied for user 'root'@'localhost'

Posted: Sat Mar 07, 2009 4:56 am
by senthil babu
i have used PHP my admin with out a user name and password before...

like

Code: Select all

<?php
mysql_connect("localhost","","");
mysql_select_db("db name");
?>
But now i dont know why it shows the error
#1045 - Access denied for user 'root'@'localhost' (NO password)
i think i did some installation mistake..
where is the mistake occours