修改MySQL 8 密码报错
mysql> set global validate_password_policy=LOW;
ERROR 1193 (HY000): Unknown system variable 'validate_password_policy'
mysql> set global validate_password_length=5;
ERROR 1193 (HY000): Unknown system variable 'validate_password_length'
此命令在MySQL 5.x 好使,在8版本不好使
解决方法:
mysql> set global validate_password.policy=0;
Query OK, 0 rows affected (0.00 sec)
mysql> set global validate_password.length=4;
Query OK, 0 rows affected (0.00 sec)