The Event Scheduler and MySQL Privileges The user waits for a minute or so, and then performs a  SELECT * FROM mytable;  query, expecting to see several new rows in the table. Instead, the table is empty. Since the user does not have the  INSERT privilege for the table in question, the event has no effect. If you inspect the MySQL error log ( hostname .err ), you can see that the event is executing, but the action it is attempting to perform fails: 2013-09-24T12:41:31.261992Z 25 [ERROR] Event Scheduler: [jon@ghidora][cookbook.e_store_ts] INSERT command denied to user ’jon’@’ghidora’ for table ’mytable’ 2013-09-24T12:41:31.262022Z 25 [Note] Event Scheduler: [jon@ghidora].[myschema.e_store_ts] event execution failed. 2013-09-24T12:41:41.271796Z 26 [ERROR] Event Scheduler: [jon@ghidora][cookbook.e_store_ts] INSERT command denied to user ’jon’@’ghidora’ for table ’mytable’ 2013-09-24T12:41:41.272761Z 26 [Note] Event Scheduler: [jon@ghidora].[myschema.e_store_ts] event execution failed. mysql>  INSERT INTO myschema.mytable VALUES (UNIX_TIMESTAMP()); ERROR 1142 (42000): INSERT command denied to user ’jon’@’ghidora’ for table ’mytable’ mysql>  SELECT * FROM INFORMATION_SCHEMA.EVENTS > WHERE EVENT_NAME=’e_store_ts’ > AND EVENT_SCHEMA=’myschema’\G *************************** 1. row *************************** EVENT_CATALOG: NULL EVENT_SCHEMA: myschema EVENT_NAME: e_store_ts DEFINER: jon@ghidora EVENT_BODY: SQL EVENT_DEFINITION: INSERT INTO myschema.mytable VALUES (UNIX_TIMESTAMP()) EVENT_TYPE: RECURRING EXECUTE_AT: NULL INTERVAL_VALUE: 5 INTERVAL_FIELD: SECOND SQL_MODE: NULL STARTS: 0000-00-00 00:00:00 ENDS: 0000-00-00 00:00:00 STATUS: ENABLED ON_COMPLETION: NOT PRESERVE CREATED: 2006-02-09 22:36:06 LAST_ALTERED: 2006-02-09 22:36:06 LAST_EXECUTED: NULL EVENT_COMMENT: 1 row in set (0.00 sec) Revoking the  EVENT  privilege from a user does not delete or disable any events that may have been created by that user. REVOKE EVENT ON myschema.* FROM jon@ghidora; To rescind the  EVENT  privilege, use the  REVOKE  statement. In this example, the  EVENT  privilege on the schema  myschema  is removed from the  jon@ghidora  user account: 4743 Important Since this user very likely does not have access to the error log, it is possible to verify whether the event’s action statement is valid by executing it directly: Inspection of the  INFORMATION_SCHEMA.EVENTS  table shows that  e_store_ts  exists and is enabled, but its  LAST_EXECUTED  column is  NULL :