Syntax
VALIDATE_PASSWORD_STRENGTH(str)
Purpose
The VALIDATE_PASSWORD_STRENGTH function returns an integer that indicates the strength of the specified password string. The return value ranges from 0 (weak) to 100 (strong). The system variables involved in password evaluation can be viewed by using the SHOW VARIABLES LIKE 'validate_password%'; statement.
Examples
obclient [test]> SELECT VALIDATE_PASSWORD_STRENGTH('ob$_@123');
+----------------------------------------------+
| VALIDATE_PASSWORD_STRENGTH('ob$_@123') |
+----------------------------------------------+
| 100 |
+----------------------------------------------+
1 row in set
