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:
Is this correct.. I think answer should be D
I think it should be B
Yes, D would be the answer.
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.
D
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
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.
B states: “ALL of requirements of the MEDIUM policy..”. So B il false 😉
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
D