- How To Reset The Root Password In The Mysql Reference Manual On Mac Computer
- How To Reset The Root Password In The Mysql Reference Manual On Mac Pro
- How To Reset The Root Password In The Mysql Reference Manual On Mac Download
I just reinstalled MySQL using brew on my mac.As far as I can see everything works fine, but I cannot change my root password.
When trying I'm getting this error message:
The common way to solve this seems to use (several answers on stack overflow suggest using this):
Short video describing how to change lost mysql root password on Mac OS X (Mavericks). Install MySQL and Set MySQL root user password on Mac OS X. Forgot your Mac Password? Reset it Without.
How To Reset The Root Password In The Mysql Reference Manual On Mac Computer
I stopped the server before executing the command. But this solution does not work for me.
There is also no entry in the error log:
I read also about using mysql_secure_installation but there I get just the same error message as when using mysql -u root.
As I mentioned above, I tried already to just uninstall and reinstall it again, but obviously some data remained. So is there maybe any way to manually delete or reset these files?
2 Answers
How To Reset The Root Password In The Mysql Reference Manual On Mac Pro
Solution by OP.
It turned out that:
(not sure if sudo is necessary)
works for me.
The access denied is because you're not specifying the -p switchIf you know the old password then maybe login to MySql and change it as: 1).login to MySql 2).change to the correct db 3) change the passwd and flush
mysql> flush privileges; mysql> quit
Also, the following works in Linux/Unix systems but i haven't tested it on Mac (may work if you have the clients installed)
Reference: https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html
//If you don't remember the password, to recover it check this out(bottom).