新安装好的mysql5.7数据库，用root登录以后执行操作报这个错。
解决方法：
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
相关文章
- ERROR 1820 (HY000): You must reset your password using ALTER USER statement
- windows下忘记mysql超级管理员root密码的解决办法(也适用于wamp） 如果报错 You must reset your password using ALTER USER statement before executing this statement.解决Your password has expired. To log in you must change it using a client that supports expired passwo
- 【mysql】must reset your password using ALTER USER statement before executing this statement
- 第一次登录mysql，使用任何命令都报错ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
- ERROR 1862 (HY000): Your password has expired. To log in you must change it using a .....
- mysql 报错ERROR 1820 (HY000): You must reset your password usi
- You must reset your password using ALTER USER statement before executing this statement.
- mysql 报错ERROR 1820 (HY000): You must reset your password usi
- MySQL5.7 报错 ERROR 1820 (HY000): You must reset your password
- linux - mysql 异常：ERROR 1820 (HY000): You must SET PASSWORD before executing this statement