首页 > 代码库 > 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.

 

报错

在连接mysql执行语句时报错:

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

 

解决办法

 

执行语句:

alter user ‘root‘@localhost identified by ‘root‘;

这样就可以了。

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