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';