Collections:
VALIDATE_PASSWORD_STRENGTH() - Password Strength Test
How to test the strength of a password using the VALIDATE_PASSWORD_STRENGTH() function?
✍: FYIcenter.com
VALIDATE_PASSWORD_STRENGTH(password) is a MySQL built-in function that
calculates the strength of a given password.
It requires validate_password plugin component to be installed.
For example:
SELECT VALIDATE_PASSWORD_STRENGTH('MyPassword');
-- +------------------------------------------+
-- | VALIDATE_PASSWORD_STRENGTH('MyPassword') |
-- +------------------------------------------+
-- | 0 |
-- +------------------------------------------+
INSTALL COMPONENT 'file://component_validate_password';
SELECT VALIDATE_PASSWORD_STRENGTH('MyPassword');
-- +------------------------------------------+
-- | VALIDATE_PASSWORD_STRENGTH('MyPassword') |
-- +------------------------------------------+
-- | 50 |
-- +------------------------------------------+
SELECT VALIDATE_PASSWORD_STRENGTH('123456');
-- +--------------------------------------+
-- | VALIDATE_PASSWORD_STRENGTH('123456') |
-- +--------------------------------------+
-- | 25 |
-- +--------------------------------------+
SELECT VALIDATE_PASSWORD_STRENGTH('123');
-- +-----------------------------------+
-- | VALIDATE_PASSWORD_STRENGTH('123') |
-- +-----------------------------------+
-- | 0 |
-- +-----------------------------------+
SELECT VALIDATE_PASSWORD_STRENGTH('430LwchJ$n');
-- +------------------------------------------+
-- | VALIDATE_PASSWORD_STRENGTH('430LwchJ$n') |
-- +------------------------------------------+
-- | 100 |
-- +------------------------------------------+
Reference information of the VALIDATE_PASSWORD_STRENGTH() function:
VALIDATE_PASSWORD_STRENGTH(password): score Normalizes a given MySQL statement into a statement digest. Arguments, return value and availability: password: Required. The password string to be tested. score: Return value. The test score between 0 and 100. Available since MySQL 4.1. Test criteria and scores: Criteria Score -------- ----- Length < 4 0 Length ≥ 4 and < validate_password.length 25 Satisfies policy 1 (LOW) 50 Satisfies policy 2 (MEDIUM) 75 Satisfies policy 3 (STRONG) 100
⇒ MySQL Functions on UUID Values
⇐ UNCOMPRESSED_LENGTH() - Uncompressed Data Length
2024-12-18, 2964🔥, 0💬
Popular Posts:
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...
What Is a Parameter File in Oracle? A parameter file is a file that contains a list of initializatio...
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...