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, 1343🔥, 0💬
Popular Posts:
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...