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‘;