您的密码不符合当前的政策要求 [英] Your password does not satisfy the current policy requirements

问题描述

我想使用以下语法在mysql中创建新用户:

I want to create a new user in mysql with 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文档

这篇关于您的密码不符合当前的政策要求的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！