MySQL ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)

Hola Amigos,

I was building Mozillians and as it requires MySQL I was trying to login to root user ‘root@localhost’ by running the following command:

mysql -u root -p

It asked to “Enter Password:”

As I had installed it long back I thought that I probably forgot my password because I had tried many combinations and it kept saying:

“ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)”

Problem:
Cannot login to the root user in mysql.

Solution:
Solution is infact quite simple. Just enter blank password.

Voila, I am logged into ‘root@localhost’. 😀

It may sound like a very trivial thing but when you try out things after a long time you tend to forget passphrases and settings that we had configured.

Hope this helps out my readers who forgot what they had “not-entered” as their passwords 😛 🙂

Let the Windows be open, and feel the Freedom.