- Mac OS X - Reset MySQL Root Password
- 在mac下reset root password后登录时有时会出现:
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
解决方法:Reset MySQL root password using ALTER USER statement after install on Mac
If you started mysql using mysql -u root -p
Try ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘MyNewPass’;