Bug #80860 Strange behaviour for PASSWORD function in 5.7
| Submitted: | 25 Mar 2016 10:35 | Modified: | 26 Mar 2016 5:11 |
|---|---|---|---|
| Reporter: | Jean-Marie Renouard (OCA) | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Server: Security: Privileges | Severity: | S3 (Non-critical) |
| Version: | 5.7, 5.7.11, 5.6.29 | OS: | Linux |
| Assigned to: | CPU Architecture: | Any |
[26 Mar 2016 5:11]
MySQL Verification Team
Hello Jean-Marie Renouard, Thank you for the report. Observed with 5.6.29 and 5.7.11. Thanks, Umesh
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.040 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.
Description: Hi, Context: SHOW PLUGINS; validate_plugin is activated. | validate_password | ACTIVE | VALIDATE PASSWORD | validate_password.so | GPL | This check is performed by mysqltuner and we can't not control password. Problem found: SELECT CONCAT(user, '@', host) FROM mysql.user WHERE authentication_string = PASSWORD('dba') OR authentication_string = PASSWORD(UPPER('dba')) OR authentication_string = PASSWORD(UPPER(LEFT('dba', 1)) + SUBSTRING('dba', 2, LENGTH('dba'))) Result: ERROR 1819 (HY000): Your password does not satisfy the current policy requirements Awaited result: As I am not in a update or set password password function shouldn't produce an error. As I am not trying to update password I shouldn't have an error. I just try to control password over a list of dummy password. How to repeat: Problem found: SELECT CONCAT(user, '@', host) FROM mysql.user WHERE authentication_string = PASSWORD('dba') OR authentication_string = PASSWORD(UPPER('dba')) OR authentication_string = PASSWORD(UPPER(LEFT('dba', 1)) + SUBSTRING('dba', 2, LENGTH('dba'))) with plugin validate_password activated Suggested fix: IF PASSWORD IS CALLED IN A SELECT STATEMENT DON'T PERFORM CHECK.