Tutorial on resetting the root password of Mac MySQL

Disclaimer: This password reset method can directly reset the password of MySQL installed by Homebrew. For MySQL installed by other methods, you only need to switch to the corresponding installation directory.

If you forget your password after installing MySQL for a long time, here is a summary of how to reset the local MySQL Root password when you forget your password.

All operations are completed in the Mac Terminal.

Stop services and processes:

brew services stop mysql

Go into the folder:

cd /usr/local/opt/mysql/bin

Execute unauthorized command (mysql):

mysqld_safe --user=mysql --skip-grant-tables --skip-networking &

Enter the MySQL command using (mysql):

mysql -u root mysql

Execute the change password code:

UPDATE mysql.user
     SET authentication_string = PASSWORD('MyNewPass'), password_expired = 'N'
     WHERE User = 'root' AND Host = 'localhost';
FLUSH PRIVILEGES;

quit:

quit;

Restart:

brew services restart mysql
mysql.server restart

New password login:

mysql -u root -p

Summarize

The above is the tutorial on how to reset the Root password of Mac MySQL introduced by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!