MySQL 8 Administrator???s Guide

The password validation plugin

For password validation, MySQL provides a plugin named validate_password. It is mainly used to test passwords and improve security. The following are the two major capabilities of this plugin:

• VALIDATE_PASSWORD_STRENGTH(): An SQL function used to find the strength of a password. It takes a password as an argument and returns an integer value between 0 and 100. Here, 0 indicates a weak password and 100 indicates a strong password.

• Check password as per policy in SQL statements: For all the SQL statements which use a password as a clear text value, the plugin will check the provided password against the policy of the password and, based on that, return a response. In the case of a weak password, the plugin ...