主页 / dba / 问题 / 267558
Accepted
Evan Carroll
Asked: 2020-05-21 11:57:35 +0800 CST

生成与密码验证组件匹配的密码

  • 772

MySQL 8 有一个非常复杂的“密码验证组件”（它取代了validate_password插件）。它有很多选择，

  • validate_password.number_count
  • validate_password.mixed_case_count
  • validate_password.special_char_count
  • validate_password.dictionary_file
  • validate_password.length

鉴于这些都可以由用户设置，是否有机制保证生成满足这一点的随机密码？是编写一个更改密码以在设置验证组件时暂停验证组件的 UI 的唯一方法吗？

mysql mysql-8.0

1 个回答

  1. Best Answer

    要在创建新密码时为用户生成随机密码，您可以使用：

    
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)
    • 4

相关问题