MySQL执行语句错误
mysql> use mysql;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql> show databases;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement。
按照普遍的做法,直接修改密码等级和权限也不行
mysql> set global validate_password.policy=0;
mysql> set global validate_password.length=1;
并且发现输入任何语句都错误
解决办法:
1.先修改一个符合它要求的密码,我修改的如图:
mysql> alter user ‘root’@‘localhost’ identified by ‘MYsql123/*’ ;
2.在修改密码等级权限
3.刷新
4.最后修改自己