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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.055 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.