MySQL 5.7 进行如下设置
mysql> set global validate_password_policy=0;
mysql> set global validate_password_length=1;
在MySQL8.0中执行以上代码会报如下错误:
mysql> set global validate_password_policy=0;
ERROR 1193 (HY000): Unknown system variable 'validate_password_policy'
mysql> set global validate_password_length=1;
ERROR 1193 (HY000): Unknown system variable 'validate_password_length'
解决方案:
MySQL 8.0 执行代码:
mysql> set global validate_password.policy=0;
mysql> set global validate_password.length=1;