content_image/776404.jpg content_image/776421.jpg content_image/776406.jpg
<img src='content_image/776404.jpg'>

The minimum number of nonalphanumeric 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. 

## Password Validation Component Status Variables 

If the validate_password  component is enabled, it exposes status variables that provide operational information: 

mysql> SHOW STATUS LIKE ’validate_password.%’; +-----------------------------------------------+---------------------+ | Variable_name | Value | +-----------------------------------------------+---------------------+ | validate_password.dictionary_file_last_parsed | 2019-10-03 08:33:49 | | validate_password.dictionary_file_words_count | 1902 | +-----------------------------------------------+---------------------+ 

The following list describes the meaning of each status variable. 

• validate_password.dictionary_file_last_parsed 

When the dictionary file was last parsed. This variable is unavailable unless validate_password  is installed. 

• validate_password.dictionary_file_words_count 

The number of words read from the dictionary file. This variable is unavailable unless validate_password  is installed. 

## Password Validation Plugin Options 

<img src='content_image/776421.jpg'>

To control activation of the validate_password  plugin, use this option: 

• --validate-password[= value ] 

## Note 

In MySQL 8.0, the validate_password  plugin was reimplemented as the validate_password  component. The validate_password  plugin is deprecated; expect it to be removed in a future version of MySQL. Consequently, its options are also deprecated, and you should expect them to be removed as well. MySQL installations that use the plugin should make the transition to using the component instead. See Section 6.4.3.3, “Transitioning to the Password Validation Component” . 

<img src='content_image/776406.jpg'>

