千家信息网

ERROR 1820 (HY000): You must reset your password

发表于:2025-02-01 作者:千家信息网编辑
千家信息网最后更新 2025年02月01日,数据库安装后执行命令ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executi
千家信息网最后更新 2025年02月01日ERROR 1820 (HY000): You must reset your password

数据库安装后执行命令ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.


解决办法:

mysql> SET PASSWORD = PASSWORD('password123!');


mysql> ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;




0