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!';
le.li