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

mysql8安装完成以后,修改初始密码报错:

mysql> ALTER USER ‘root’@’%’ IDENTIFIED WITH mysql_native_password BY ‘MyNewPass4!ysp123456’;

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

修改root的初始密码:

ALTER USER USER() IDENTIFIED BY 'MyNewPass4!ysp123456';