Hello, i had same problem on wamp 2.1e but now i fix it.
UPDATE mysql.user
I was writing ( UPDATE mysql ) : so please follow the next steps if you want to resolve your problem with ( #1045 - Access denied for user 'root'@'localhost' (using password: NO):
1 : go to your WAMP icon on your PC desktop screen and LEFT CLICK to open the menu, you will see MYSQL folder, CLICK to see MYSQL CONSOLE, open it.
2: now you have DOS screen ( a black screen ) :
A: if you already set a password, type it
B: if you did not do this step yet, write the following red text
B1: use mysql; and click ENTER on your keyboard
3: now write the following red text and click ENTER :
UPDATE mysql.user
->SET Password=PASSWORD("*******")
->WHERE User="root";
don't use space on the code and don't worry about this sign ( -> ) , because for example when you write ( UPDATE mysql.user ) and you click ENTER on your keyboard, a new line appear with this sign ( -> ), your command will execute when you write this sign ( ; ) at the end of your text and click ENTER.
NOTE: replace the password ******* by your password.
example:
UPDATE mysql.user
->SET Password=PASSWORD("rabbyweb")
->WHERE User="root"
;
4: now write the following red text and press ENTER :
FLUSH PRIVILEGES;
5: and to exit the black DOS screen now, write exit and press enter.
exit
------------------------- we are finished from MySQL now --------------
6: go to WAMP folder ( open your My Computer, click on C driver, and you will see WAMP folder ), click on APPS folder, and than click on your PHPMYADMIN folder ( e.g my folder called phpmyadmin3.3.9 ) [for me C:\wamp\apps\phpmyadmin3.3.9] and find the config.inc.php
7: open config.inc.php and find the following text:
$cfg['Servers'][$i]['password'] = '';
and add your password now that you used in step number 3 like that :
$cfg['Servers'][$i]['password'] = 'yourpassword/rabbyweb ';
and if this line is false make it true
$cfg['Servers'][$i]['AllowNoPassword'] = true;
8: now save this modification, and close config.inc.php
9: go to your web browser and type the following link :
http://localhost/phpmyadmin/
if until it's like that before. please clean your Browser History,Cache, Cookies,
and enjoy, this is what happened with me.
Thanks