MySQL 8有一个相当复杂的“密码验证组件” (这取代了validate_password插件)。它有很多选择,
validate_password.number_countvalidate_password.mixed_case_countvalidate_password.special_char_countvalidate_password.dictionary_filevalidate_password.length考虑到所有这些都可以由用户设置,是否有机制保证生成满足这一要求的随机密码?在设置验证组件时,是否编写更改密码以挂起验证组件的UI的唯一方法?
发布于 2020-05-27 10:32:04
要在创建新密码的同时为用户生成随机密码,可以使用:
mysql> CREATE USER ran_user@localhost IDENTIFIED BY RANDOM PASSWORD;
+----------+-----------+----------------------+
| user | host | generated password |
+----------+-----------+----------------------+
| ran_user | localhost | UN:5_z05J._*VtU3K%Qu |
+----------+-----------+----------------------+
1 row in set (0.10 sec)要更改当前/现有用户的密码,可以使用以下语句:
mysql> ALTER USER ran_user@localhost IDENTIFIED BY RANDOM PASSWORD;
+----------+-----------+----------------------+
| user | host | generated password |
+----------+-----------+----------------------+
| ran_user | localhost | (YU>{}tu&6@[U%!Pdw>n |
+----------+-----------+----------------------+
1 row in set (0.16 sec)这个RANDOM PASSWORD关键字满足密码验证器组件:
mysql> show global variables like '%validate%';
+--------------------------------------+--------+
| 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.23 sec)https://dba.stackexchange.com/questions/267558
复制相似问题