ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
解决方法
1. 先给root用户设置一个密码,输入:
ALTER USER USER() IDENTIFIED BY '新密码';
2. 然后,Quit退出
3. 再用新的密码登录
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
解决方法
1. 先给root用户设置一个密码,输入:
ALTER USER USER() IDENTIFIED BY '新密码';
2. 然后,Quit退出
3. 再用新的密码登录