VALIDATE_PASSWORD_STRENGTH

Syntax

VALIDATE_PASSWORD_STRENGTH(str)

Description

For a specified password string, returns an integer indicating the password strength. The return value ranges from 0 (weak) to 100 (strong). The system variables involved in password evaluation can be viewed by executing SHOW VARIABLES LIKE 'validate_password%';.

Examples

SELECT VALIDATE_PASSWORD_STRENGTH('ob$_@123');
+----------------------------------------------+
| VALIDATE_PASSWORD_STRENGTH('ob$_@123') |
+----------------------------------------------+
|                                          100 |
+----------------------------------------------+
1 row in set (0.001 sec)