Shulou(Shulou.com)06/01 Report--

Statement: this reset password can directly reset the password of the MySQL installed by Homebrew. For the MySQL installed in other ways, you need to change the corresponding installation directory.

If you forget your password after installing MySQL for too long, here's a summary of how to reset your local MySQL Root password if you forget your password.

All operations are done in the Mac terminal (Terminal).

Stop services and processes:

Brew services stop mysql

Enter the folder:

Cd / usr/local/opt/mysql/bin

Execute the ultra vires order (mysql):

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

Use (mysql) to enter the MySQL command:

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

Exit:

Quit

Restart:

Brew services restart mysqlmysql.server restart

Login with new password:

Mysql-u root-p

Summary

The above is the tutorial of Mac MySQL reset Root password introduced by Xiaobian to you. I hope it will be helpful to you. If you have any questions, please leave me a message and the editor will reply you in time. Thank you very much for your support to the website!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.