Fix MySQL 5.7 ERROR 1524 (HY000): Plugin ‘auth_socket’ is not loaded in macOS Big Sur

fix_mysql_big_sur.sh

# If you don't use brew services, install it
# https://github.com/Homebrew/homebrew-services

# Stop MySQL
brew services stop [email protected]

# Start MySQL in safe mode
mysqld_safe --skip-grant-tables &

# Login to MySQL
mysql -u root

# Use "mysql" table
use mysql;
 
# Update the authentication
update user set authentication_string=PASSWORD('') where User='root';
update user set plugin='mysql_native_password' where User='root';
 
# Flush the privilges and quit
flush privileges;
quit;
 
# Restart MySQL
/usr/local/opt/[email protected]/bin/mysql.server stop
brew services start [email protected]