首页 > 其他分享 >ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this st

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

时间:2022-11-18 11:00:59浏览次数:49  
标签:reset 1820 HY000 executing USER statement ALTER before

首先安装后,执行任何指令都会提示:

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;

注意指令末尾的分号。

退出后重新登陆。

标签:reset,1820,HY000,executing,USER,statement,ALTER,before
From: https://www.cnblogs.com/yanghj010/p/16902512.html

相关文章