Password policies in MySQL - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a password policy in MySQL?

A password policy in MySQL is a set of rules that define the requirements for user passwords to improve security, such as minimum length, complexity, and expiration.

beginner

Which MySQL system variable controls the password validation policy?

The validate_password.policy system variable controls the password validation policy in MySQL.

intermediate

What are the possible values for validate_password.policy in MySQL?

Possible values are LOW, MEDIUM, and STRONG. Each level enforces different password complexity rules.

intermediate

How can you set the minimum password length to 10 characters in MySQL?

Use the command: <br>SET GLOBAL validate_password.length = 10; <br>This sets the minimum password length to 10 characters.

beginner

What happens if a password does not meet the current MySQL password policy?

MySQL will reject the password change or creation and return an error, forcing the user to choose a password that meets the policy requirements.

Which MySQL plugin is commonly used to enforce password policies?

A validate_password

B audit_log

C replication

D performance_schema

The validate_password plugin enforces password complexity and policy rules.

What does setting validate_password.policy to STRONG require?

A Only minimum length

B Length, mixed case, numbers, and special characters

C No restrictions

D Only numbers

STRONG policy requires passwords to have a minimum length and include uppercase, lowercase, numbers, and special characters.

How do you check the current password policy level in MySQL?

A DESCRIBE password_policy;

B SELECT * FROM users;

C SHOW VARIABLES LIKE 'validate_password.policy';

D SHOW STATUS;

The command SHOW VARIABLES LIKE 'validate_password.policy'; shows the current password policy level.

If you want to disable password validation temporarily, what should you do?

A DROP USER 'root';

B SET GLOBAL validate_password.policy = LOW;

C SET GLOBAL validate_password.length = 0;

D UNINSTALL PLUGIN validate_password;

Uninstalling the validate_password plugin disables password validation.

Which command sets the minimum number of special characters required in a password?

A SET GLOBAL validate_password.special_char_count = 2;

B SET GLOBAL validate_password.number_count = 2;

C SET GLOBAL validate_password.mixed_case_count = 2;

D SET GLOBAL validate_password.length = 2;

The variable validate_password.special_char_count sets the minimum special characters required.

Explain how MySQL enforces password policies and how you can configure them.

Think about the plugin and system variables that control password rules.

Describe the steps to change the password policy to require at least 12 characters and 2 special characters.

Focus on system variables related to length and special characters.