L
L
LearnJava
Search…
⌃K

Mac_mysql问题

1. 进入mysql后运行命令报错

报错内容: You must reset your password using ALTER USER statement before executing this statement.
解决方案:
step 1: SET PASSWORD = PASSWORD('your new password');
step 2: ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
step 3: flush privileges;

2. 更新root密码

mysql> use mysql;
mysql> UPDATE user SET Password = PASSWORD('newpass') WHERE user = 'root';
mysql> FLUSH PRIVILEGES;