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, 2241🔥, 0💬
Popular Posts:
How to put statements into a statement block in SQL Server Transact-SQL? You can put statements into...
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...