Bug #68300 alter user password expire will cause crash when start with skip-grant_tables
Submitted: 7 Feb 2013 8:31 Modified: 1 Mar 2013 16:54
Reporter: xiaobin lin (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Security: Privileges Severity:S3 (Non-critical)
Version:5.6.6+ OS:Any
Assigned to: CPU Architecture:Any
Tags: alter user password expire, crash, skip-grant_tables

[7 Feb 2013 8:31] xiaobin lin
Description:
The server crash when start with skip-grant_tables, and then run a command like "alter user 'root'@'localhost' password expire;"

How to repeat:
as above

my make and run OS
Linux  2.6.32-220.23.1.tb704.el6.x86_64 #1 SMP Thu Aug 23 17:16:25 CST 2012 x86_64 x86_64 x86_64 GNU/Linux

Suggested fix:
When start with skip-grant_tables, this command should be prevent like other grant operations, and returns "ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement"
[7 Feb 2013 8:33] xiaobin lin
based on 5.6.10

Attachment: 5.6.10.user_password_expire.diff (application/octet-stream, text), 543 bytes.

[7 Feb 2013 10:58] Erlend Dahl
Thank you for the bug report. Reproducible on recent 5.6.
[1 Mar 2013 16:54] Paul DuBois
Noted in 5.6.11, 5.7.1 changelogs.

If the server was started with --skip-grant-tables, ALTER USER ...
PASSWORD EXPIRE caused the server to exit.