A.The validate_password plug-in has not been loaded.

B.validate_password_policy cannot be set without restarting the MySQL instance.

C.validate_password_dictionary_file cannot be set without restarting the MySQL instance.

D.The dictionary file word list is too short.

E.The name of the dictionary file is too obvious.

F.The dictionary file is in an insecure location.

A.The validate_password plug-in has not been loaded.

B.The dictionary file word list is too short.

C.The dictionary file is in an insecure location.

D.The name of the dictionary file is too obvious.

E.validate_password_policy cannot be set without restarting the MySQL instance.

F.validate_password_dictionary_file cannot be set without restarting the MySQL instance.

A.allowing a client to shut down the server

B.allowing client accounts to take over the account of another user

C.allowing change of the server runtime configuration

D.allowing a client to kill other client connections

A.mysql> CREATE USER 'robert'@'localhost' IDENTIFIED BY 'secret_password';mysql>CREATE USER 'employee'@'localhost' IDENTIFIED BY 'more_secrets';

B.mysql> CREATE USER 'employee'@'localhost' IDENTIFIED BY 'more_secrets';mysql> GRANT PROXY ON 'employee'@'localhost' TO 'robert'@'localhost';

C.mysql> CREATE_USER ''@'' IDENTIFIED WITH authentication_pam ACCOUNT LOCK;mysql> CREATE USER 'employee'@'localhost' IDENTIFIED BY 'more_secrets';mysql> GRANT PROXY ON 'employee'@'localhost' TO ''@'';

D.mysql> CREATE USER 'employee'@'localhost' IDENTIFIED BY 'more_secrets';mysql> CREATE USER ''@'' IDENTIFIED BY 'valid_password' WITH PROXY 'employee'@'localhost';

A.internal temporary table

B.sort buffer

C.read buffer

D.thread cache

E.InnoDB buffer pool instance

F.query cache