I am working on a PR for this.

wenhug pointed out that MySQL docs (https://dev.mysql.com/doc/refman/8.0/en/server-options.html#option_mysqld_skip-grant-tables) reference this behavior (event scheduler disabled as a side effect of --skip-grant-tables).

We should update MariaDB docs to explain it as well.

PR that addresses this was submitted in https://github.com/MariaDB/server/pull/2539 (posting URL here since the Jira git integration is broken and most people reading this Jira will not see the link unless it is posted in a comment).

Although my PR was approved and merged by danblack, back in April, a recently commit by serg largely reverts it, by removing the distinctive error message for this specific case.

https://github.com/MariaDB/server/commit/eb9ff262e461938a69a9a594e0d3df4037a84fd6#diff-5b5c10b1c90df86d3d3a1a12eafcb34a891dd64897f84a930bcbb25762fe8141

Sergei, can you explain why you decided to revert this change?

Did I? There is still an error message when an event scheduler is disabled by --bootstrap or --skip-grants. There is still a message in the error log when a user tries to enable event scheduler with --bootstrap or --skip-grants.

I just consolidated error numbers, using the same error code that the server uses in all similar cases. And I've clarified it, so that the server would directly say what option caused the event scheduler to be disabled, instead of listing every possible option and letting user to figure it out what exactly was used. Otherwise the PR works as merged, reporting both an error to the user and a message to the log.

And I've clarified it, so that the server would directly say what option caused the event scheduler to be disabled, instead of listing every possible option and letting user to figure it out what exactly was used.

Yeah, that's true. It is an improvement to be explicit about whether it's -bootstrap or -skip-grant-tables which is causing the error (rather than "one or the other")

I just consolidated error numbers, using the same error code that the server uses in all similar cases.

I see. And the consolidated replacement is The MariaDB server is running with the (-skip-grant-tables|-bootstrap) option so it cannot execute this statement.

When I wrote this Jira, I was coming from the point of view that it's very non-obvious which functionality is or isn't disabled by -skip-grant-tables and/or -bootstrap, and that each piece of missing functionality should be individually explained. The documentation of --skip-grant-tables only says that it "gives all users FULL ACCESS to all tables", but doesn't say anything about disabling Event Scheduler or other functionality.

Probably the documentation for -skip-grant-tables and -bootstrap should be updated to specifically mention that Event Scheduler is disabled, so that when end-users get this error message, they're able to find documentation that specifically mentions that this is expected behavior?

Probably the documentation for --skip-grant-tables and --bootstrap should be updated to specifically mention that Event Scheduler is disabled, so that when end-users get this error message, they're able to find documentation that specifically mentions that this is expected behavior?

Done.

https://mariadb.com/kb/en/mariadbd-options/#-skip-grant-tables

https://mariadb.com/kb/en/event-limitations/

Thanks. Another explanation could be that with --skip-grant-tables no tables are read from mysql.* on startup, so all features that need that are disabled. Applies to privileges, UDFs, events, plugins.

I see. And the consolidated replacement is "The MariaDB server is running with the (-skip-grant-tables|-bootstrap) option so it cannot execute this statement"

Yes, this is the error message the server uses when, well, some functionality is disabled by a certain command-line option.
Few examples from existing tests:

INSERT INTO db1.t1 VALUES (1);

ERROR HY000: The MariaDB server is running with the --read-only option so it cannot execute this statement

--

ALTER TABLE t1 REBUILD PARTITION ALL;

ERROR HY000: The MariaDB server is running with the --skip-partition option so it cannot execute this statement

--

SELECT * INTO OUTFILE 'MYSQL_TMP_DIR\\..a..\\..\\..\\B11764517-2.tmp' FROM t1;

ERROR HY000: The MariaDB server is running with the --secure-file-priv option so it cannot execute this statement

--

set password for bar@foo = password("pass word");

ERROR HY000: The MariaDB server is running with the --skip-grant-tables option so it cannot execute this statement