For SQL statements that assign a password supplied as a cleartext value, validate_password checks the password against the current password policy and rejects the password if it is weak (the statement returns an ER_NOT_VALID_PASSWORD error). 对于将密码指定为明文值的SQL语句，validate_password会根据当前密码策略检查密码，如果密码较弱，则拒绝该密码（该语句返回ER_NOT_VALID_PASSWORD错误）。This applies to the ALTER USER, CREATE USER, and SET PASSWORD statements.

For CREATE USER statements, validate_password requires that a password be given, and that it satisfies the password policy. 对于CREATE USER语句，validate_password要求提供密码，并且该密码满足密码策略。This is true even if an account is locked initially because otherwise unlocking the account later would cause it to become accessible without a password that satisfies the policy.即使帐户最初被锁定，这也是正确的，因为否则稍后解锁帐户会导致它在没有满足策略的密码的情况下变得可访问。

validate_password implements a VALIDATE_PASSWORD_STRENGTH() SQL function that assesses the strength of potential passwords. validate_password实现了一个VALIDATE_PASSWORD_STRENGTH()SQL函数，用于评估潜在密码的强度。This function takes a password argument and returns an integer from 0 (weak) to 100 (strong).此函数接受密码参数，并返回一个从0（弱）到100（强）的整数。

validate_password checks the cleartext password in the following statement. Under the default password policy, which requires passwords to be at least 8 characters long, the password is weak and the statement produces an error:validate_password在以下语句中检查明文密码。在默认密码策略下，要求密码长度至少为8个字符，密码很弱，语句会产生错误：

mysql> ALTER USER USER() IDENTIFIED BY 'abc';
ERROR 1819 (HY000): Your password does not satisfy the current
policy requirements

Passwords specified as hashed values are not checked because the original password value is not available for checking:指定为哈希值的密码不会被检查，因为原始密码值不可用于检查：

mysql> ALTER USER 'jeffrey'@'localhost'
IDENTIFIED WITH mysql_native_password
AS '*0D3CED9BEC10A777AEC23CCC353A8C08A633045E';
Query OK, 0 rows affected (0.01 sec)

This account-creation statement fails, even though the account is locked initially, because it does not include a password that satisfies the current password policy:即使帐户最初被锁定，此帐户创建语句也会失败，因为它不包含满足当前密码策略的密码：

mysql> CREATE USER 'juanita'@'localhost' ACCOUNT LOCK;
ERROR 1819 (HY000): Your password does not satisfy the current
policy requirements

To check a password, use the VALIDATE_PASSWORD_STRENGTH() function:要检查密码，请使用VALIDATE_PASSWORD_STRENGTH()函数：

mysql> SELECT VALIDATE_PASSWORD_STRENGTH('weak');
+------------------------------------+
| VALIDATE_PASSWORD_STRENGTH('weak') |
+------------------------------------+
|                                 25 |
+------------------------------------+
mysql> SELECT VALIDATE_PASSWORD_STRENGTH('lessweak$_@123');
+----------------------------------------------+
| VALIDATE_PASSWORD_STRENGTH('lessweak$_@123') |
+----------------------------------------------+
|                                           50 |
+----------------------------------------------+
mysql> SELECT VALIDATE_PASSWORD_STRENGTH('N0Tweak$_@123!');
+----------------------------------------------+
| VALIDATE_PASSWORD_STRENGTH('N0Tweak$_@123!') |
+----------------------------------------------+
|                                          100 |
+----------------------------------------------+

LOW policy tests password length only. LOW策略仅测试密码长度。Passwords must be at least 8 characters long. To change this length, modify validate_password.length.密码长度必须至少为8个字符。要更改此长度，请修改validate_password.length。

MEDIUM policy adds the conditions that passwords must contain at least 1 numeric character, 1 lowercase character, 1 uppercase character, and 1 special (nonalphanumeric) character. MEDIUM策略添加了密码必须至少包含1个数字字符、1个小写字符、1个中大写字符和1个特殊（非字母数字）字符的条件。To change these values, modify validate_password.number_count, validate_password.mixed_case_count, and validate_password.special_char_count.要更改这些值，请修改validate_passwordnumber_count、validate_passwardmixed_case_count和validate_password.special_char_count。

STRONG policy adds the condition that password substrings of length 4 or longer must not match words in the dictionary file, if one has been specified. STRONG策略添加了一个条件，即长度为4或更长的密码子字符串不得与词典文件中的单词匹配（如果已指定）。To specify the dictionary file, modify validate_password.dictionary_file.要指定词典文件，请修改validate_passworddictionary_file。