Mac Mysql 重置密码

Mac Mysql 重置密码

• 操作系统：Mac
• Mysql 版本：5.7.20

---

sudo ./mysqld_safe –skip-grant-tables
mysql> UPDATE mysql.user
SET authentication_string = PASSWORD(‘your_new_password’)
WHERE User=’root’;
mysql> FLUSH PRIVILEGES;

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

mysql> SET PASSWORD = PASSWORD(‘your_new_password’);
Query OK, 0 rows affected, 1 warning (0.01 sec)

重新登陆开启mysql ， ./mysql -uroot -p