[MySQL] ERROR 1862 (HY000): Your password has expired. To log the must change it using a client that supports expired passwords.

Source: Internet
Author: User



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.


Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.