Home/ Questions/Q 6814
In Process
Alek Richter
  • 0
Enlightened
Asked: 2021-12-22T01:53:43+00:00

Your password does not satisfy the current policy requirements

  • 0

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

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

But it returns an error:

Your password does not satisfy the current policy requirements.

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

1 Answer

  2. Enlightened

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

    SHOW VARIABLES LIKE 'validate_password%';

    The output should be something like that :

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

    Check the MySQL Documentation.

    • 0
Leave an answer

Leave an answer

Browse