What is the MySQL8.0 password policy?
This article mainly explains "what is the MySQL8.0 password strategy". The explanation in the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "what is the MySQL8.0 password policy".
Since 8.0.4, mysql has abandoned the long-used validate_password plug-in and used validate_password components instead.
My version is:
Mysql > select version (); +-+ | version () | +-+ | 8.0.14 | +-+ 1 row in set (0.00 sec)
Let's check the password policy parameters:
Mysql > SHOW VARIABLES LIKE 'validate_password.%';Empty set (0.00 sec)
Because the validate_password component is not installed, the installation begins below:
Mysql > INSTALL COMPONENT 'file://component_validate_password';Query OK, 0 rows affected (0.00 sec)
Just check it again.
Mysql > SHOW VARIABLES LIKE 'validate_password%' +-- +-+ | Variable_name | Value | +-- +-+ | validate_password.check_ User_name | ON | | 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.00 sec)
Another change is that, in the past, the parameter used to be underlined, and now it is. You should pay attention to it when modifying it.
Mysql > set global validate_password.policy=low;Query OK, 0 rows affected (0.00 sec) mysql > SHOW VARIABLES LIKE 'validate_password%' +-- +-+ | Variable_name | Value | +-- +-+ | validate_password.check_user_ Name | ON | | validate_password.dictionary_file | | validate_password.length | 8 | validate_password.mixed_case_count | 1 | validate_password.number_count | 1 | validate_password.policy | LOW | | validate_password.special_char_count | 1 | +- -+-+ 7 rows in set (0.00 sec) Thank you for your reading The above is the content of "what is the MySQL8.0 password policy". After the study of this article, I believe you have a deeper understanding of what the MySQL8.0 password policy is, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!
