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)”
Cannot login to the root user in mysql.
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.