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.