关闭mysql密码策略_MySQL 5.7 关闭密码策略设置validate_password

错误：

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

查看密码策略，改过的：

mysql> show variables like '%valid%';

+--------------------------------------+-------+

| Variable_name | Value |

+--------------------------------------+-------+

| query_cache_wlock_invalidate | OFF |

| validate_password_check_user_name | OFF |

| validate_password_dictionary_file | |

| validate_password_length | 8 |

| validate_password_mixed_case_count | 1 |

| validate_password_number_count | 1 |

| validate_password_policy | LOW |

| validate_password_special_char_count | 1 |

+--------------------------------------+-------+

8 rows in set (0.00 sec)

如果不需要密码策略，在my.cnf文件中添加如下配置禁用即可：

validate_password = off