降低mysql 密码_mysql 修改密码策略

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

set global  validate_password_length =0;

set global validate_password_mixed_case_count=0;

set global validate_password_number_count=0;

set global validate_password_policy=0;

set global validate_password_special_char_count =0;

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

mysql启动失败看日志：/var/log/mysqld.log