mysql 修改密码策略

时间:2022-02-17 06:30:34

show variables like ‘validate_password%‘; 查看密码策略


| validate_password_check_user_name | OFF |
| validate_password_dictionary_file | |
| validate_password_length | 0 |
| validate_password_mixed_case_count | 0 |
| validate_password_number_count | 0 |
| validate_password_policy | LOW |
| validate_password_special_char_count | 0 |

将各个属性修改为0,即可降低密码严格度

修改后重置密码

alter user ‘root‘@‘localhost‘ identified by ‘1234‘;