Bug #75918 mysqld --init-file doesn\'t accept grant statements

• Submitted: 16 Feb 2015 13:27
• Modified: 28 Aug 2015 14:04
• Reporter: Bernt Marius Johnsen
• Status: Closed
• Category: MySQL Server: Security: Privileges
• Severity: S3 (Non-critical)
• Version: 5.7.6
• OS: Any
• CPU Architecture: Any

[16 Feb 2015 13:27] Bernt Marius Johnsen

Description:
When booting mysqld with --initialize (or --initialize-insecure) and --init-file, you get

2015-02-16T12:57:48.291555Z 1 [ERROR] 1290  The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement

if the init file contains a grant statement

How to repeat:
boot with an --init-file with a grant statement

Suggested fix:
Allow grant statements during initialization phase

[28 Aug 2015 14:04] Paul Dubois

Noted in 5.7.9, 5.8.0 changelogs.

If a file was specified using an --init-file option, mysqld
--initialize produced errors for statements in the file such as GRANT
that affect user accounts.