Shulou(Shulou.com)06/01 Report--

1, password authentication plug-in installation

For the server to be available, the plug-in library file must be located in the MySQL plug-in directory (the directory specified by the plugin_dir system variable). The plug-in library file base name is validate_password.so.

Show variables like'% plugin%'

To register the plug-in at run time, use this statement

INSTALL PLUGIN validate_password SONAME 'validate_password.so'

INSTALL PLUGIN loads the plug-in and registers it in the mysql.plugins system table to start loading the plug-in for each subsequent normal server.

To verify the plug-in installation, check the INFORMATION_SCHEMA.PLUGINS table or use the SHOW PLUGINS statement 10:47:11 (none) > SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE 'validate%' +-+-+ | PLUGIN_NAME | PLUGIN_STATUS | +-+-+ | validate_password | ACTIVE | +-- -+ 1) first check the global parameter configuration of mysql. This problem is actually related to the value of validate_password_policy of mysql. Check out several global parameters related to the msyql password: 10:47:12 (none) > select @ @ validate_password_policy +-- + | @ @ validate_password_policy | +-- + | MEDIUM | +-+ 1 row in set (0.00 sec) 10:49:07 (none) > SHOW VARIABLES LIKE 'validate_password%' +-- +-+ | Variable_name | Value | +-+-+ | validate_password_check_user_name | OFF | | validate _ password_dictionary_file | validate_password_length | 8 | validate_password_mixed_case_count | 1 | validate_password_number_count | 1 | validate_password_policy | MEDIUM | | validate_password_special_char_count | 1 | +-- +-+ 7 rows in set (0.04 sec)

2) Parameter interpretation

Validate_password_length

The minimum password length. The default parameter is 8, which is limited by the minimum value: validate_password_number_count + validate_password_special_char_count + (2 * validate_password_mixed_case_count).

Validate_password_mixed_case_count

The password should contain at least the number of lowercase letters and uppercase letters.

Validate_password_number_count

The password must contain at least the number of digits

Validate_password_policy

Password strength check level: 0/LOW, 1/MEDIUM, 2/STRONG. The default is 1, that is, MEDIUM, so the password you set at the beginning must match the length and must contain numbers, lowercase or uppercase letters, and special characters.

Validate_password_special_char_count

At least the number of special characters that the password must contain.

3) change password policy and modify simple password set global validate_password_policy=0; set global validate_password_mixed_case_count=0; set global validate_password_number_count=0; set global validate_password_special_char_count=0

Set global validate_password_length=4

Change the simple password:

Mysql > SET PASSWORD FOR 'root'@'localhost' = PASSWORD (' root')

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.