validate_password.check_user_name

Whether validate_password compares passwords to the user name part of the effective user account for the current session and rejects them if they match. This variable is unavailable unless validate_password is installed.validate_password是否将密码与当前会话的有效用户帐户的用户名部分进行比较，如果匹配则拒绝密码。除非安装了validate_password，否则此变量不可用。

By default, validate_password.check_user_name is enabled. 默认情况下，validate_password.check_user_name处于启用状态。This variable controls user name matching independent of the value of validate_password.policy.此变量控制用户名匹配，与validate_password.policy的值无关。

When validate_password.check_user_name is enabled, it has these effects:启用validate_password.check_user_name后，它具有以下效果：

validate_password.dictionary_file

The path name of the dictionary file that validate_password uses for checking passwords. This variable is unavailable unless validate_password is installed.validate_password用于检查密码的字典文件的路径名。除非安装了validate_password，否则此变量不可用。

By default, this variable has an empty value and dictionary checks are not performed. For dictionary checks to occur, the variable value must be nonempty. 默认情况下，此变量的值为空，不执行字典检查。为了进行字典检查，变量值必须非空。If the file is named as a relative path, it is interpreted relative to the server data directory. 如果文件被命名为相对路径，则它将相对于服务器数据目录进行解释。File contents should be lowercase, one word per line. 文件内容应小写，每行一个单词。Contents are treated as having a character set of utf8. The maximum permitted file size is 1MB.内容被视为具有utf8字符集。允许的最大文件大小为1MB。

For the dictionary file to be used during password checking, the password policy must be set to 2 (STRONG); see the description of the validate_password.policy system variable. 对于要在密码检查期间使用的词典文件，密码策略必须设置为2(STRONG)；请参阅validate_password.policy系统变量的描述。Assuming that is true, each substring of the password of length 4 up to 100 is compared to the words in the dictionary file. Any match causes the password to be rejected. Comparisons are not case-sensitive.假设这是真的，将长度为4到100的密码的每个子字符串与字典文件中的单词进行比较。任何匹配都会导致密码被拒绝。比较不区分大小写。

For VALIDATE_PASSWORD_STRENGTH(), the password is checked against all policies, including STRONG, so the strength assessment includes the dictionary check regardless of the validate_password.policy value.对于VALIDATE_PASSWORD_STRENGTH()，将根据所有策略（包括STRONG）检查密码，因此强度评估包括字典检查，而不管validate_password.policy值如何。

validate_password.dictionary_file can be set at runtime and assigning a value causes the named file to be read without a server restart.validate_password.dictionary_file可以在运行时设置，分配一个值会导致在不重新启动服务器的情况下读取命名文件。

validate_password.length

The minimum number of characters that validate_password requires passwords to have. This variable is unavailable unless validate_password is installed.validate_password要求密码具有的最小字符数。除非安装了validate_password，否则此变量不可用。

The validate_password.length minimum value is a function of several other related system variables. The value cannot be set less than the value of this expression:validate_password.length最小值是其他几个相关系统变量的函数。该值不能设置为小于此表达式的值：

validate_password.number_count
+ validate_password.special_char_count
+ (2 * validate_password.mixed_case_count)

If validate_password adjusts the value of validate_password.length due to the preceding constraint, it writes a message to the error log.如果validate_password由于前面的约束而调整了validate_password.length的值，它会将一条消息写入错误日志。

validate_password.mixed_case_count

The minimum number of lowercase and uppercase characters that validate_password requires passwords to have if the password policy is MEDIUM or stronger. This variable is unavailable unless validate_password is installed.如果密码策略为MEDIUM或更高，则validate_password要求密码具有的最小小写和大写字符数。除非安装了validate_password，否则此变量不可用。

For a given validate_password.mixed_case_count value, the password must have that many lowercase characters, and that many uppercase characters.对于给定的validate_password.mixed_case_count值，密码必须有那么多小写字符和那么多大写字符。

validate_password.number_count

The minimum number of numeric (digit) characters that validate_password requires passwords to have if the password policy is MEDIUM or stronger. 如果密码策略为MEDIUM或更高，则validate_password要求密码具有的最小数字字符数。This variable is unavailable unless validate_password is installed.除非安装了validate_password，否则此变量不可用。

validate_password.policy

The password policy enforced by validate_password. This variable is unavailable unless validate_password is installed.由validate_password执行的密码策略。除非安装了validate_password，否则此变量不可用。

validate_password.policy affects how validate_password uses its other policy-setting system variables, except for checking passwords against user names, which is controlled independently by validate_password.check_user_name.validate_password.policy影响validate_password如何使用其其他策略设置系统变量，但根据用户名检查密码除外，这由validate_password.check_user_name独立控制。

The validate_password.policy value can be specified using numeric values 0, 1, 2, or the corresponding symbolic values LOW, MEDIUM, STRONG. validate_password.policy值可以使用数值0、1、2或相应的符号值LOW、MEDIUM、STRONG指定。The following table describes the tests performed for each policy. 下表描述了为每个策略执行的测试。For the length test, the required length is the value of the validate_password.length system variable. 对于长度测试，所需的长度是validate_password.length系统变量的值。Similarly, the required values for the other tests are given by other validate_password.xxx variables.同样，其他测试所需的值由其他validate_password.xxx变量给出。

validate_password.special_char_count

The minimum number of nonalphanumeric characters that validate_password requires passwords to have if the password policy is MEDIUM or stronger. 如果密码策略为MEDIUM或更高，则validate_password要求密码具有的非字母数字字符的最小数量。This variable is unavailable unless validate_password is installed.除非安装了validate_password，否则此变量不可用。

validate_password.dictionary_file_last_parsed

When the dictionary file was last parsed. This variable is unavailable unless validate_password is installed.上次解析词典文件的时间。除非安装了validate_password，否则此变量不可用。

validate_password.dictionary_file_words_count

The number of words read from the dictionary file. This variable is unavailable unless validate_password is installed.从词典文件中读取的单词数。除非安装了validate_password，否则此变量不可用。

--validate-password[=value]

This option controls how the server loads the deprecated validate_password plugin at startup. 此选项控一致性务器在启动时如何加载已弃用的validate_password插件。The value should be one of those available for plugin-loading options, as described in Section 5.6.1, “Installing and Uninstalling Plugins”. 该值应该是插件加载选项可用的值之一，如第5.6.1节，“安装和卸载插件”所述。For example, --validate-password=FORCE_PLUS_PERMANENT tells the server to load the plugin at startup and prevents it from being removed while the server is running.例如，--validate-password=FORCE_PLUS_PERMANENT告诉服务器在启动时加载插件，并防止在服务器运行时将其删除。

This option is available only if the validate_password plugin has been previously registered with INSTALL PLUGIN or is loaded with --plugin-load-add. 仅当validate_password插件之前已在INSTALL PLUGIN中注册或已使用--plugin-load-add加载时，此选项才可用。See Section 6.4.3.1, “Password Validation Component Installation and Uninstallation”.请参阅第6.4.3.1节，“密码验证组件的安装和卸载”。

validate_password_check_user_name

This validate_password plugin system variable is deprecated; expect it to be removed in a future version of MySQL. 此validate_password插件系统变量已弃用；预计它将在MySQL的未来版本中被删除。Use the corresponding validate_password.check_user_name system variable of the validate_password component instead.请改用validate_password组件的相应validate_password.check_user_name系统变量。

validate_password_dictionary_file

This validate_password plugin system variable is deprecated; expect it to be removed in a future version of MySQL. 此validate_password插件系统变量已弃用；预计它将在MySQL的未来版本中被删除。Use the corresponding validate_password.dictionary_file system variable of the validate_password component instead.请改用validate_password组件的相应validate_password.dictionary_file系统变量。

validate_password_length

This validate_password plugin system variable is deprecated; expect it to be removed in a future version of MySQL. Use the corresponding validate_password.length system variable of the validate_password component instead.此validate_password插件系统变量已弃用；预计它将在MySQL的未来版本中被删除。请改用validate_password组件的相应validate_password.length系统变量。

validate_password_mixed_case_count

This validate_password plugin system variable is deprecated; expect it to be removed in a future version of MySQL. Use the corresponding validate_password.mixed_case_count system variable of the validate_password component instead.此validate_password插件系统变量已弃用；预计它将在MySQL的未来版本中被删除。请改用validate_password组件的相应validate_password.mixed_case_count系统变量。

validate_password_number_count

This validate_password plugin system variable is deprecated; expect it to be removed in a future version of MySQL. 此validate_password插件系统变量已弃用；预计它将在MySQL的未来版本中被删除。Use the corresponding validate_password.number_count system variable of the validate_password component instead.请改用validate_password组件的相应validate_password.number_count系统变量。

validate_password_policy

This validate_password plugin system variable is deprecated; expect it to be removed in a future version of MySQL. 此validate_password插件系统变量已弃用；预计它将在MySQL的未来版本中被删除。Use the corresponding validate_password.policy system variable of the validate_password component instead.请改用validate_password组件的相应validate_password.policy系统变量。

validate_password_special_char_count

This validate_password plugin system variable is deprecated; expect it to be removed in a future version of MySQL. 此validate_password插件系统变量已弃用；预计它将在MySQL的未来版本中被删除。Use the corresponding validate_password.special_char_count system variable of the validate_password component instead.请改用validate_password组件的相应validate_password.special_char_count系统变量。

validate_password_dictionary_file_last_parsed

This validate_password plugin status variable is deprecated; expect it to be removed in a future version of MySQL. 此validate_password插件状态变量已弃用；预计它将在MySQL的未来版本中被删除。Use the corresponding validate_password.dictionary_file_last_parsed status variable of the validate_password component instead.请改用validate_password组件的相应validate_password.dictionary_file_last_parsed状态变量。

validate_password_dictionary_file_words_count

This validate_password plugin status variable is deprecated; expect it to be removed in a future version of MySQL. Use the corresponding validate_password.dictionary_file_words_count status variable of the validate_password component instead.此validate_password插件状态变量已弃用；预计它将在MySQL的未来版本中被删除。请改用validate_password组件的相应validate_password.dictionary_file_words_count状态变量。