您的密码不符合当前政策要求

2022-01-22 00:00:00 passwords mysql

我想在 MySQL 中创建一个新用户，语法如下:

I want to create a new user in MySQL with the syntax:

create user 'demo'@'localhost' identified by 'password';

但是它返回一个错误:

您的密码不满足当前的政策要求.

Your password does not satisfy the current policy requirements.

我尝试了很多密码，但都不起作用.我该如何解决这个问题?

I have tried many passwords but they don't work. How can I fix this?

推荐答案

因为你的密码.您可以在 MySQL 客户端中使用以下查询查看密码验证配置指标:

Because of your password. You can see password validate configuration metrics using the following query in MySQL client:

SHOW VARIABLES LIKE 'validate_password%';

输出应该是这样的:

+--------------------------------------+-------+
| Variable_name                        | Value |
+--------------------------------------+-------+
| validate_password.check_user_name    | ON    |
| validate_password.dictionary_file    |       |
| validate_password.length             | 6     |
| validate_password.mixed_case_count   | 1     |
| validate_password.number_count       | 1     |
| validate_password.policy             | LOW   |
| validate_password.special_char_count | 1     |
+--------------------------------------+-------+

那么你可以将密码策略级别设置得更低，例如:

then you can set the password policy level lower, for example:

SET GLOBAL validate_password.length = 6;
SET GLOBAL validate_password.number_count = 0;

查看 MySQL 文档.

相关文章