Shulou(Shulou.com)05/31 Report--

How to enable password strength audit in MySQL? in view of this problem, this article introduces the corresponding analysis and solution in detail, hoping to help more partners who want to solve this problem to find a more simple and easy way.

Execute the following command to install the password strength audit plug-in:

Mysql > INSTALL PLUGIN validate_password SONAME 'validate_password.so'

Set the strongest password policy:

Mysql > set global validate_password_policy=strong

Query OK, 0 rows affected (0.00 sec)

Or add some password strength related parameters through the configuration file my.cnf:

[mysqld]

Plugin-load=validate_password.so

Validate_password_policy=2

Validate-password=FORCE_PLUS_PERMANENT

Then execute the show plugins command to see if it is enabled successfully:

Mysql > show plugins

+-+

| | Name | Status | Type | Library | License | |

+-+

| | validate_password | ACTIVE | VALIDATE PASSWORD | validate_password.so | GPL | |

+-+

The parameters related to password strength audit after setting are as follows:

Mysql > show global variables like 'validate%'

+-+ +

| | Variable_name | Value |

+-+ +

| | validate_password_dictionary_file |

| | validate_password_length | 8 |

| | validate_password_mixed_case_count | 1 | |

| | validate_password_number_count | 1 | |

| | validate_password_policy | STRONG |

| | validate_password_special_char_count | 1 | |

+-+ +

6 rows in set (0.00 sec)

-- change the password. If you do not comply with the rules, you will report an error.

Mysql > SET PASSWORD = PASSWORD ('123456')

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

Mysql > SET PASSWORD = PASSWORD ('aisino 123')

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

Modified successfully, at least 1 case plus numbers and special characters, and at least 8 characters in password length:

Mysql > SET PASSWORD = PASSWORD ('Aisino 123 characters');-- uppercase and lowercase codes plus numbers and special characters, at least 8 digits

Query OK, 0 rows affected (0.00 sec)

The relevant parameters are explained as follows:

The parameter validate_password_policy is used to control the authentication policy of validate_password: 0murf-> low 1mure-> MEDIUM 2muri-> strong.

The minimum length of the validate_password_length password (the minimum is 4).

The minimum number of digits in the validate_password_number_count password.

The minimum number of validate_password_mixed_case_count case.

The minimum number of validate_password_special_char_count special characters.

Validate_password_dictionary_file dictionary file (the dictionary file path used by the plug-in to verify password strength)

This is the answer to the question about how to enable password strength audit in MySQL. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel for more related knowledge.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.