mysql 8.0.16 初次登录修改密码

mysql数据库初始化后初次登录需要修改密码

初次登录会碰到下面这个错误

ql> alter user root identified by ‘password’;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

需要使用下面的命令来修改密码

mysql> alter user user() identified by ‘password’;
Query OK, 0 rows affected (1.43 sec)