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-

1 comment:

  1. Hi, Great.. Tutorial is just awesome..It is really helpful for a newbie like me.. I am a regular follower of your blog. Really very informative post you shared here. Kindly keep blogging. If anyone wants to become a Java developer learn from Java EE Online Training from India. or learn thru Java EE Online Training from India . Nowadays Java has tons of job opportunities on various vertical industry.