MySQL :: #1045 - Access denied for user 'root'@'localhost' (using password: NO)

By Default MySQL Server didn’t use a password to access it. And a default user name ‘root’ is used to access MySQL Server.

Manually we can set a new user name and a password to access MySQL Server.

·        Open this URL : http://localhost/phpmyadmin/

·        Click on the Privileges tab.

·        Here you may ‘Add a New User’ or edit privileges of default user.

·        Edit Privileges: User 'root'@'localhost'

·        Set a new password for default user ‘root’

·        Refresh the URL : http://localhost/phpmyadmin/

·        Now you will face an error like this:

It shows that you can not view Localhost without a password.

SOLUTION:

• Open this file :
• C:\wamp\apps\phpmyadmin3.2.0.1\config.inc
• Find this statement:
• $cfg['Servers'][$i]['password'] = '';
• And replace with this statement:
• $cfg['Servers'][$i]['password'] = 'yourpassword';