Geek Essential Objectively finite, subjectively infinite.

18Apr/110

phpMyAdmin 1045 Access Denied error!

 

Having internet is like a double edged sword. On one hand, you have endless amount of information at your finger tip (literally), but asking the right question is the key of find that information your need in any given moment. Also, there's that problem of information overflow which is another issue all together, but I digress.

As a web admin / net admin / just a handy IT guy around the office, I do use phpMyAdmin quite often because its interface is much easier to navigate than terminal. Also, I'm a visual person and like to see large amount of data in nice tables. Today however, I was faced with an issue. I was not able to access it. Following was the error message that I've got.

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

 

To make sure I've tried to access it from the terminal using

mysql -u root

 

but the problem persisted. So on to the Google I went and searched online for the error message and apparently, this was a common instance that came up from time to time. After going through few of the top links, I've found following solution http://tekxplorer.blogspot.com/2010/05/phpmyadmin-mysql-error-1045-access.html which was easier than what other's have suggested and you know what? It works! thanks you internet and that guy who posted his experience :)

If you don't feel like following the link to the solution page, basically this is what you need to do...

  1. Add '/scripts/signon.php" at the end of your site URL, so that it will look like http://yourdomain.com/phpmyadmin/scripts/signon.php"
  2. From the sign on page, login using your root user id and password for mySQL
  3. Ta-da, you are back in!

After doing this once, problem with the access denied error seems to magically disappear. Well, one less worry for me and I'll know what to do next time ;-)

 

Comments (0) Trackbacks (0)

No comments yet.


Leave a comment

(required)

No trackbacks yet.