Bug #80428 --skip-grant-tables disables event scheduler even after flush privileges
Submitted: 18 Feb 2016 12:16
Reporter: Georgi Iovchev Email Updates:
Status: Open Impact on me:
Category:MySQL Server Severity:S4 (Feature request)
Version:5.6 OS:Any
Assigned to: CPU Architecture:Any
Tags: skip-grant-tables event-scheduler

[18 Feb 2016 12:16] Georgi Iovchev
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@ (root@) [(none)]> flush privileges\G
root@ (root@) [(none)]> select @@global.event_scheduler;
| @@global.event_scheduler |
| DISABLED                 |
1 row in set (0.00 sec)
root@ (root@) [(none)]> \q

Connect again and try to enable event scheduler
root@ (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).