MySQL Password Enhanced plugin _mysql

Introduced

Have not been too careful about the MySQL password security policy configuration method, but the artificial password is set to a complex password, but did not find the method of configuration, today Kang's micro-letter public number just released a article about this, so here also by the way to write down. First of all, this feature is in the MySQL version after 5.5 before the introduction of Plug-ins, the default source code installation and binary installation does not enable the feature, if the feature is not turned on to set a simple password MySQL will only give a hint but will allow the pass.

Enable Features

Add in My.cnf file

Plugin-load=validate_password.so 

Analysis function

Show variables like ' validate% ';

1. Validate_password_policy

Represents the password policy that can be configured with the following values: Default is Medium

0 or low only needs to match the password length (specified by the parameter validate_password_length)
1 or MEDIUM satisfies the low policy, while at least 1 digits, lowercase letters, uppercase letters, and special characters are required

2.validate_password_dictionary_file

A dictionary file for configuring passwords that can be configured with a password dictionary file when Validate_password_policy is set to strong, and passwords that exist in the dictionary file must not be used.

3.validate_password_length

The minimum length used to set the password, the default is 8, and the minimum is 0.

4.validate_password_mixed_case_count

When Validate_password_policy is set to Medium or strong, the number of lowercase and uppercase letters that are at least at the same time in the password is 1 and the default is 0; The default is to have at least one lowercase and one uppercase letter.

5.validate_password_number_count

When Validate_password_policy is set to Medium or strong, the number of digits at least in the password, the default 1 is the minimum of 0

6.validate_password_special_char_count

When Validate_password_policy is set to Medium or strong, the number of special characters that are at least in the password, the default 1 is the minimum of 0

Test

The first password is not long enough and has no uppercase letters, the second password is long enough but there is no capital letter

Reference Links:

http://mp.weixin.qq.com/s?__biz=MjM5MjIxNDA4NA==&mid=2649737686&idx=1&sn= C92874c88ff8e07a199d5ef81fbae359&scene=23&srcid=0701fj032ojwrfev9edsm10s

Summarize

Increasing the complexity of the password requires a significant improvement in the security of the system, especially when it is necessary to enable it on the online system.

The above is a small set to introduce the MySQL password enhancements plug-ins, 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!