MySql5.6 use the validate password plug-in to enhance the installation and use of the password strength, mysql5.6validate

MySql5.6 use the validate password plug-in to enhance the installation and use of the password strength, mysql5.6validate

Mysql 5.6 enhanced the password strength and launched the validate_password plug-in. Supports password strength requirements.

Installation Method:

Open in configuration file

[Mysqld]

plugin-load=validate_password.sovalidate-password=FORCE_PLUS_PERMANENTvalidate_password_policy=2

And load plugin:

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

You can.

When a user password is created, if it does not comply with the preset rules, it will not pass:

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

Next we will introduce the use of the mysql 5.6 password strength plug-in.

In mysql 5.6, the password strength was enhanced, and the validate_password plug-in was launched. Supports password strength requirements.

Required version: 5.6.6 or later

Installation Method:

1. Install the plug-in: (after the plug-in is installed by default, the strength plug-in is enabled and disabled. In the configuration file, if the relevant parameters are disabled)

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

2. Add some parameters to the configuration file:

plugin-load=validate_password.sovalidate_password_policy=2validate-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 requirementsmysql> SET PASSWORD = '*0D3CED9BEC10A777AEC23CCC353A8C08A633045E';

JQuery OK, 0 rows affected (0.01 sec)

4. Instructions:

(1). Related options:

Validate-password = ON/OFF/FORCE/FORCE_PLUS_PERMANENT: determines whether to use this 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.

(2) 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 when the server is running (it will be registered in the mysql. plugins table)

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

(3). To prevent the plug-in from being deleted at runtime, add the following in the configuration file:

plugin-load=validate_password.sovalidate-password=FORCE_PLUS_PERMANENT

The above section describes how to install and use the validate password plug-in MySql5.6 to enhance the password strength. I hope it will help you. If you have any questions, please leave a message, the editor will reply to you in a timely manner. Thank you very much for your support for the help House website!