When installing MySQL5.6 to create a user and create a password, the system always prompts that the password does not meet the requirements: ERRO_MySQL

When installing MySQL5.6 to create a user and create a password, the system always prompts that the password does not meet the requirements: ERROR1819 (HY000): YourpassworddoesNOT .. solve bitsCN.com

When installing MySQL5.6 to create a user and create a password, the system always prompts that the password does NOT meet the requirements: ERROR 1819 (HY000): Your password does NOT satisfy the CURRENT solution.

When installing MySQL5.6 to create a user and create a password, the system always prompts that the password does NOT meet the requirements: ERROR 1819 (HY000): Your password does NOT satisfy the CURRENT policy requirements.

Check that the original password strength verification plug-in validate_password was added to MySQL5.6.6. the relevant parameter settings are strict, so ......

When this plug-in is used, the system checks whether the configured password meets the strength rules set Currently. if not, the system rejects the settings. The affected statements and functions include: create user, grant, set password, password (), and old password.

The password strength can be evaluated by the validate password strength () function (the number between 0 and 100 is returned), for example:

mysql>select VALIDATE_PASSWORD_STRENGTH('123456');mysql>select VALIDATE_PASSWORD_STRENGTH('Password@123456');

Note that the hashed passwords are not verified, for example:

mysql> SET PASSWORD = PASSWORD('abc');ERROR 1819 (HY000): Your password does not satisfy the current policy requirementsmysql> SET PASSWORD = '*0D3CED9BEC10A777AEC23CCC353A8C08A633045E';Query OK, 0 rows affected (0.01 sec)

Related options:

-- Validate-password = ON/OFF/FORCE/FORCE_PLUS_PERMANENT: determines whether to use the plug-in (and FORCE/Permanent FORCE ).

Validate_password_dictionary_file: the dictionary file path used by the plug-in to verify the password strength.

Validate_password_length: minimum password length.

Validate_password_mixed_case_count: minimum number of lower-case letters and upper-case letters to be included in the password.

Validate_password_number_count: the minimum number of digits to be included in the password.

Validate_password_policy: Password strength check level, 0/LOW, 1/MEDIUM, 2/STRONG.

Validate_password_special_char_count: the minimum number of special characters to be included in the password.

Here, about validate_password_policy-password strength check grade:

0/LOW: check the length only.

1/MEDIUM: check the length, number, case, and special characters.

2/STRONG: check the length, number, case, and special character dictionary file.

Install and enable the plug-in:

The library object file corresponding to the plug-in must be in the directory specified by the plugin_dir configuration option.

You can use -- plugin-load = validate_password.so to load the plug-in at server startup, or write plugin-load = validate_password.so to the configuration file.

You can also use the following statement to load the plug-in (will be registered into the mysql. plugins table) at the server runtime mysql> install plugin validate_password SONAME 'validate _ password. so ';

To prevent this plug-in from being deleted at runtime, you can add it to the configuration file:

[mysqld]plugin-load=validate_password.sovalidate-password=FORCE_PLUS_PERMANENT

BitsCN.com