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
2023-12-14, 235🔥, 0💬
Popular Posts:
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" ...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...
What Is an Oracle Tablespace in Oracle? An Oracle tablespace is a big unit of logical storage in an ...
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...