Thursday, February 11, 2016

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


While installing the WAMP server I was having the issue of MYSQL connection as I had provided my own passward in MYSQL-

1045 - Access denied for user 'root'@'localhost' (using password: NO)  error when typing http://localhost/phpmyadmin in browser.
Solution:
Go to file C:\wamp\apps\phpmyadmin4.1.14\config.inc.php
Go to the line $cfg['Servers'][$i]['password']='' and change this to
$cfg['Servers'][$i]['password']='NO'
Try opening phpMyAdmin again, and hopefully  message will read as "Access denied for user 'root'@'localhost' (using password: YES)
Now change the password in the above line to 'yourpassword' (whatever you had set it to before)

And here we go-


No comments:

Post a Comment