MySQL:You must reset your password using ALTER USER statement before executing this statement.

mysql版本5.7.31

首次初始化mysql，服务启动成功，登录成功

执行很多命令都报错

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

解决：

MySQL版本5.7.6版本以前用户可以使用如下命令：
SET PASSWORD = PASSWORD('newPassword');

MySQL版本5.7.6版本开始的用户可以使用如下命令：
ALTER USER USER() IDENTIFIED BY 'newPassword!';