Installing MySQL today encounters such a problem:
ERROR 1862 (HY000): Your password has expired. To log the must change it using a client that supports expired passwords.
It means that the password has expired.
Changed the password:
mysql> SET PASSWORD = PASSWORD(‘abc‘);
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
mysql> SET PASSWORD = ‘*0D3CED9BEC10A777AEC23CCC353A8C08A633045E‘;
Query OK, 0 rows affected (0.01 sec)
Related options: --validate-password=on/off/force/force_plus_permanent: Decide whether to use the plug-in (and force/permanently force use). Validate_password_dictionary_file: The dictionary file path that the plugin uses to verify password strength. Validate_password_length: Minimum password length. Validate_password_mixed_case_count: The password must contain at least the number of lowercase letters and uppercase letters. Validate_password_number_count: The number of digits that the password must contain at least. Validate_password_policy: Password strength check level, 0/low, 1/medium, 2/strong. Validate_password_special_char_count: The minimum number of special characters the password should contain. Where about validate_password_policy-password strength check level: 0/low: Check only the length. 1/medium: Check length, number, case, special characters. 2/strong: Check the length, number, case, and special character dictionary files. Plug-in installation enabled: The Library object file corresponding to the plugin needs to be in the directory specified in configuration options plugin_dir. 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. can also be loaded into the server runtime by using the following statement (registered into the Mysql.plugins table) mysql> INSTALL PLUGIN validate_password SONAME ' Validate_ Password.so '; To prevent the plugin from being deleted at run time, you can add the following in the configuration file:?
| 123 |
[mysqld]plugin-load=validate_password.sovalidate-password=FORCE_PLUS_PERMANENT |
[MySQL] ERROR 1862 (HY000): Your password has expired. To log the must change it using a client that supports expired passwords.
