mysql> set global validate_password.policy=0;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql是8.0.35版本,linux是centos 7
在执行set global validate_password.policy=0;时报错,在网上找了半天也没找到解决办法。最后发现只要重置成功一遍密码就行了。
输入以下语句:
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password';
密码部分要有大小写和符号
之后就不会再报错了
mysql> set global validate_password.policy=0;
Query OK, 0 rows affected (0.00 sec)
mysql> set global validate_password.length=1;
Query OK, 0 rows affected (0.01 sec)
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
Query OK, 0 rows affected (0.00 sec)