MySql5.6 use validate password plug-in to strengthen the installation and use of password strength _mysql

MySQL 5.6 On the strength of the password has been enhanced, the introduction of the Validate_password plug-in. Support the strength requirements for passwords.

Installation method:

Open in configuration file

[Mysqld]

plugin-load=validate_password.so
validate-password=force_plus_permanent
validate_password_policy=2

and load plugin:

Mysql>>install PLUGIN validate_password soname ' validate_password.so ';

Can.

When a user's password is established, it does not pass if the preset rules are not met:

Mysql>grant all on *.* to tester@ ' localhost ' identified by ' tasssss ';
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements;

Next to introduce the MySQL 5.6 Password strength plug-in use

In MySQL 5.6 The strength of the password was strengthened and the Validate_password plugin was introduced. Support the strength requirements for passwords.

This plugin requires version: 5.6.6 above

Installation method:

1. Install Plug-ins: (the default installation of Plug-ins, strength plug-ins on the enabled, close, need to be in the configuration file if relevant shutdown parameters)

Mysql>install PLUGIN validate_password soname ' validate_password.so ';

2. Add some parameters to the configuration file:

plugin-load=validate_password.so
validate_password_policy=2
validate-password=force_plus_permanent

3. After the above processing, you can test:

mysql> SET PASSWORD = PASSWORD (' abc ');
ERROR 1819 (HY000): Your password does not satisfy the "current policy requirements
" mysql> SET password = ' *0d3ced9b EC10A777AEC23CCC353A8C08A633045E ';

JQuery OK, 0 rows affected (0.01 sec)

4. Related notes:

(1). Related options:

Validate-password=on/off/force/force_plus_permanent: Determines whether the plug-in is used (and enforced/permanently enforced).

Validate_password_dictionary_file: The dictionary file path that the plug-in uses to verify the password strength.

Validate_password_length: Minimum password length.

Validate_password_mixed_case_count: The password must contain at least the number of lowercase letters and the number of uppercase letters.

Validate_password_number_count: The number of digits that the password should contain at least.

Validate_password_policy: Password strength check level, 0/low, 1/medium, 2/strong.

Validate_password_special_char_count: The number of special characters that the password must contain at least.

Among them, about validate_password_policy-password strength Check level:

0/low: Check length only.

1/medium: Check length, number, case, special characters.

2/strong: Check length, number, case, special character dictionary file.

(2). Plug-in installation enabled:

The corresponding library object file for the plug-in needs to be in the directory specified by the configuration option Plugin_dir.

You can use--plugin-load=validate_password.so to load Plug-ins at server startup, or to write plugin-load=validate_password.so to a configuration file.

You can also load the plug-in when the server runs by using the following statement (registration into the Mysql.plugins table)

mysql> INSTALL PLUGIN validate_password soname ' validate_password.so ';

(3). To prevent the plug-in from being deleted at run time, add it to the configuration file:

plugin-load=validate_password.so
validate-password=force_plus_permanent

The above is a small set to introduce the MySql5.6 use validate password plug-ins to strengthen the installation of password strength and use of methods, I hope to help you, if you have any questions please give me a message, small series will promptly reply to everyone. Here also thank you very much for the cloud Habitat Community website support!