ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) would appreciate if you could please let me know A.S.A.P. Many Thanks We encourage you to read our updated PRIVACY POLICY and COOKIE POLICY.
Here are the steps to follow to fix it on Mac OS X 10.10.5 and MySQL v.5.7.10
Stop mysqld : The easiest way to stop mysqld is via MySQL in “System Preferences”. Just open it, look for MySQL and hit “Stop MySQL Server” button .
If you didn’t install this utility, you need to go with launchctl tool. Open Terminal, and enter the following command: (as root user)
sh-3.2# /usr/local/mysql/bin/mysqld -u root -p (you need to enter your new password : foobarpass )
You should be able to connect to your mysql with your new password.
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:
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 😛 🙂