One can set many requirements for password validation. The password policy must have strong otherwise you will get an error “Your password does not satisfy the current policy requirements.” Error when the user tries to set a password in MYSQL.
Where to create a password policy?
The password policy will be created in the MYSQL server, when the validate_plugin is active and this will throw an error message by saying that the password does not satisfy the current policy requirements.
This error can be fixed by three methods.
- Set the password policy value to low
- Set the same password policy value in my.cnf file
- Uninstall the plugin that is used for validating a password.
Set the password policy to low:
The default password level of the plugin can be changed at runtime or by using a config file. For this purpose, the default authentication plugin has to be checked.
SHOW VARIABLES LIKE ‘default authentication plugin’;
For checking the current variables for password validation, run the following command.
SHOW VARIABLES LIKE ‘validate_password%’;
Validate_password is a variable that is used to inform the server about the validate_password plugin. This plugin tests the passwords and improves security.
Policies in validate_password_policy:
There are three policies in Validate_password_policy. The policies are used to define the strength of the password. The default policy will be Medium and the value is changed to Low which has the password length of a minimum of 8 characters. It is only used to check the length of the password. Password policy is set by using the following command;
SET GLOBAL validate_password_policy = LOW