Bug #80428 --skip-grant-tables disables event scheduler even after flush privileges

• Submitted: 18 Feb 2016 12:16
• Reporter: Georgi Iovchev
• Status: Open
• Category: MySQL Server
• Severity: S4 (Feature request)
• Version: 5.6
• OS: Any
• CPU Architecture: Any
• Tags: skip-grant-tables event-scheduler

[18 Feb 2016 12:16] Georgi Iovchev

Description:
Starting mysql server with with --skip-grant-tables disables event scheduler.
Event scheduler cannot be enabled even after enabling flush privileges command.

How to repeat:
Start mysqld server with --skip-grant-tables.
Connect to server and execute flush privileges.

root@127.0.0.1:3306 (root@) [(none)]> flush privileges\G
root@127.0.0.1:3306 (root@) [(none)]> select @@global.event_scheduler;
+--------------------------+
| @@global.event_scheduler |
+--------------------------+
| DISABLED                 |
+--------------------------+
1 row in set (0.00 sec)
root@127.0.0.1:3306 (root@) [(none)]> \q

Connect again and try to enable event scheduler
root@127.0.0.1:3306 (root@localhost) [(none)]> set global event_scheduler=1;
ERROR 1290 (HY000): The MySQL server is running with the --event-scheduler=DISABLED or --skip-grant-tables option so it cannot execute this statement

Suggested fix:
I do not know if it is a bug or feature. According to documentation when event_scheduler is DISABLED, it can not be changed.
My suggestion is to change the behavior like that: when server is started with skip-grant-tables event_scheduler to be set to OFF (if it has not been explicitly set to DISABLED).