ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
首先安装后,执行任何指令都会提示:
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
可以用以下指令修改你密码为 123456。
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER;
之后使用以下指令刷新权限:
flush privileges;
注意指令末尾的分号。
退出后重新登陆。