What is the cause of the error?

The validate_password plugin is loaded and displays the following settings in global variables:
Mysql> SHOW VARIABLES LIKE ‘validate_password%’;

When attempting to set your password, you get the following error:
Mysql> SET PASSWORD = PASSWORD (‘Hoverl@%’);
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
What is the cause of the error?

The validate_password plugin is loaded and displays the following settings in global variables:
Mysql> SHOW VARIABLES LIKE ‘validate_password%’;

When attempting to set your password, you get the following error:
Mysql> SET PASSWORD = PASSWORD (‘Hoverl@%’);
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
What is the cause of the error?

A.
The password is eight characters long, but needs to exceed validate_password_length to be
valid.

B.
All of the MEDIUM password policy requirements have not been honored.

C.
The password matches a substring Hover as a dictionary word.

D.
The password does not match the validate_passoword_number_count requirement.

E.
There is no dictionary file defined, so password validation cannot work as expected.

Explanation:



Leave a Reply 10

Your email address will not be published. Required fields are marked *


vithiyan

vithiyan

Is this correct.. I think answer should be D

Vince

Vince

I think it should be B

Vince

Vince

Yes, D would be the answer.

Me

Me

D, – MEDIUM policy adds the conditions that passwords must contain at least 1 numeric character, 1 lowercase and uppercase character, and 1 special (nonalphanumeric) character.

dash-68

dash-68

The answer is definitely B. I tested it on version: 5.6.24:
mysqld1-(root@localhost) [test]>INSTALL PLUGIN validate_password SONAME ‘validate_password.so’;
mysqld1-(root@localhost) [test]>SHOW VARIABLES LIKE ‘validate_password%’;
+————————————–+——–+
| Variable_name | Value |
+————————————–+——–+
| validate_password_dictionary_file | |
| validate_password_length | 8 |
| validate_password_mixed_case_count | 1 |
| validate_password_number_count | 1 |
| validate_password_policy | MEDIUM |
| validate_password_special_char_count | 1 |
+————————————–+——–+

mysqld1-(root@localhost) [mysql]>SET PASSWORD = PASSWORD (‘Hoverl@%’);
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

Cristian

Cristian

The answer is both B and D. MEDUIM password policy activates the validate_password_number_count requirement, which is not met in this example, therefore D is correct if & only if B is correct.

mutex

mutex

B states: “ALL of requirements of the MEDIUM policy..”. So B il false 😉

Orby

Orby

MEDIUM policy adds the conditions that passwords must contain at least 1 numeric character, 1 lowercase character, 1 uppercase character, and 1 special (nonalphanumeric) character ==>

All of the requirements for MEIDUM policy have been met, excet for “at least 1 numeric character”.

Answer is D