ERROR 1820 (HY000): You must reset your password using ALTER USER statement

新安装好的mysql5.7数据库,用root登录以后执行操作报这个错。

ERROR 1820 (HY000): You must reset your password using ALTER USER statement

解决方法:

mysql> alter user 'root'@'localhost' identified by 'root密码'
Query OK, 0 rows affected (0.01 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> quit