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.
Go to file C:\wamp\apps\phpmyadmin4.1.14\
Go to the line $cfg['Servers'][$i]['password']='' and change this to
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