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 Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Security: Privileges Severity:S3 (Non-critical)
Version:5.7.6 OS:Any
Assigned to: CPU Architecture:Any

[16 Feb 2015 13:27] Bernt Marius Johnsen
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.