ERROR 1820 (HY000): You must reset your password

分类: 文章 • 2022-05-29 21:03:28

数据库安装后执行命令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;