content_image/734568.jpg
In addition, validate_password  supports the capability of rejecting passwords that match the user name part of the effective user account for the current session, either forward or in reverse. To provide control over this capability, validate_password  exposes a validate_password.check_user_name system variable, which is enabled by default. 

## 6.4.3.1 Password Validation Component Installation and Uninstallation 

This section describes how to install and uninstall the validate_password  password-validation component. For general information about installing and uninstalling components, see Section 5.5, “MySQL Components” . 

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

## Note 

If you install MySQL 8.0 using the MySQL Yum repository, MySQL SLES Repository, or RPM packages provided by Oracle, the validate_password component is enabled by default after you start your MySQL Server for the first time. 

Upgrades to MySQL 8.0 from 5.7 using Yum or RPM packages leave the validate_password  plugin in place. To make the transition from the validate_password  plugin to the validate_password  component, see Section 6.4.3.3, “Transitioning to the Password Validation Component” . 

To be usable by the server, the component library file must be located in the MySQL plugin directory (the directory named by the plugin_dir  system variable). If necessary, configure the plugin directory location by setting the value of plugin_dir  at server startup. 

To install the validate_password  component, use this statement: 

INSTALL COMPONENT ’file://component_validate_password’; 

Component installation is a one-time operation that need not be done per server startup. INSTALL COMPONENT  loads the component, and also registers it in the mysql.component  system table to cause it to be loaded during subsequent server startups. 

To uninstall the validate_password  component, use this statement: 

UNINSTALL COMPONENT ’file://component_validate_password’; 

UNINSTALL COMPONENT  unloads the component, and unregisters it from the mysql.component  system table to cause it not to be loaded during subsequent server startups. 

## 6.4.3.2 Password Validation Options and Variables 

This section describes the system and status variables that validate_password  provides to enable its operation to be configured and monitored. 

## Password Validation Component System Variables 

•Password Validation Component System Variables 

•Password Validation Component Status Variables 

•Password Validation Plugin Options 

•Password Validation Plugin System Variables 

•Password Validation Plugin Status Variables 

