Monday, 28 October 2013

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

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



Error: #1045 - occur when you already installed mysql with password.
After that when you will install wamp server then you will get this error.


Here is a solution for this problem:Just follow some simple steps :



1. Open C:\wamp 


2. Then open apps  folder.

3. Then open phpmyadmin3.2.0.1  folder.

4. Then you will find config.inc  file.

5. Open this file with dream weaver

6. Find $cfg['Servers'][$i]['password'] = '';

7. Replace with $cfg['Servers'][$i]['password'] = '123';   (Here 123 is password of mysql)

8.Then Find $cfg['Servers'][$i]['AllowNoPassword'] = true;

9. Replace with $cfg['Servers'][$i]['AllowNoPassword'] = false;

10. Then restart all services.

11. Enjoy.