MySQL enhanced plug-in and mysql enhanced plug-in

MySQL enhanced plug-in and mysql enhanced plug-in

Introduction

I didn't pay too much attention to the configuration method of the MySQL password security policy in the past. I just tried to set the password as a complex password, but I didn't find the configuration method, today, Jiang chengyao's public account just published an article about this, so I will also write down the method here. First, this function is a plug-in introduced in mysql versions later than mysql 5.5. This function is not enabled by default for both source code installation and binary installation, if you do not enable this function to set a simple password for mysql, you will be prompted but will still be allowed to pass.

Feature enabled

Add the following content to the my. cnf file:

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

Analysis Function

show variables like 'validate%';

1. validate_password_policy

Password Policy, which can be configured with the following values: MEDIUM by default

0 or LOW only needs to conform to the password length (specified by the validate_password_length parameter) 1 or MEDIUM meets the LOW policy and must contain at least one number and lowercase letters, uppercase letters and special characters 2 or STRONG meet the MEDIUM policy, and the password cannot exist in a dictionary file.

2. validate_password_dictionary_file

The dictionary file used to configure the password. You can configure the password dictionary file when validate_password_policy is set to STRONG. The password in the dictionary file cannot be used.

3. validate_password_length

Used to set the minimum length of the password. The default value is 8 and the minimum value is 0.

4. validate_password_mixed_case_count

When validate_password_policy is set to MEDIUM or STRONG, the minimum number of lowercase and upper-case letters in the password is 0 by default, and at least one lower-case and one upper-case letter by default.

5. validate_password_number_count

When validate_password_policy is set to MEDIUM or STRONG, the minimum number of digits in the password is 0 by default.

6. validate_password_special_char_count

When validate_password_policy is set to MEDIUM or STRONG, the minimum number of special characters in the password is 0 by default.

Test

The first password is not long enough and has no uppercase letters. The second password is long but has no uppercase letters.

Reference link:

Http://mp.weixin.qq.com? _ Biz = MjM5MjIxNDA4NA ==& mid = 2649737686 & idx = 1 & sn = Hangzhou & scene = 23 & srcid = 0701fj032oJWRFEv9eDsM10s # rd

Summary

Increasing the complexity of passwords greatly improves the security of the system. In particular, it is necessary to enable this function for online systems.

The above is the MySQL password enhancement plug-in introduced by xiaobian. I hope it will help you. If you have any questions, please leave a message and I will reply to you in a timely manner. Thank you very much for your support for the help House website!