MySQL ERROR 1524 (HY000): Plugin 'mysql_old_password' is not loaded on MacOS

Issue

After running the following commands (in an attempt to fix something else)

mysql> UPDATE mysql.user SET plugin = 'mysql_old_password'
mysql> WHERE User = 'some_user' AND Host = 'some_host';
mysql> FLUSH PRIVILEGES;
mysql> SET PASSWORD FOR
    -> 'some_user'@'some_host' = OLD_PASSWORD('new_password');

I haven’t been able to run mysql using mysql -u root as it gives me the error Plugin 'mysql_old_password' is not loaded. I have tried reinstalling mysql using homebrew and even removing some mysql folders using rm -rf and following other stack overflow posts.

EDIT:
I am using mysql version 8.0.30 for macOS 12.4
When I run sudo /usr/local/mysql/bin/mysqld_safe –skip-grant-tables I get the error sudo: /usr/local/mysql/bin/mysqld_safe: command not found.

And when I simply run sudo mysqld_safe --skip-grant-tables I get

[1] 51759
[email protected] ~ % 
[1]  + suspended (tty output)  sudo mysqld_safe --skip-grant-tables

Solution

Was given the following post on GitHub to properly uninstall MySQL so that I could reinstall it again and have it work correctly: https://gist.github.com/vitorbritto/0555879fe4414d18569d

GitHub Post by VitorBritto to properly uninstall MySQL

A comment on that post to properly uninstall MySQL on Apple Silicon devices

Answered By – The Royal Guardian

This Answer collected from stackoverflow, is licensed under cc by-sa 2.5 , cc by-sa 3.0 and cc by-sa 4.0

Leave a Reply

(*) Required, Your email will not be published