MySQL Bugs: #73082: SHOW EVENTS in performance

Bug #73082	SHOW EVENTS in performance_schema gives Access Denied
Submitted:	23 Jun 2014 17:06	Modified:	28 Oct 2014 22:32
Reporter:	Alfredo Kojima	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Performance Schema	Severity:	S3 (Non-critical)
Version:	5.6.19	OS:	Any
Assigned to:	Marc ALFF	CPU Architecture:	Any

Description:
Executing SHOW EVENTS on performance_schema returns an Access denied error, even if the user is root.
Perhaps the command should return an empty resultset instead.

How to repeat:
mysql> use performance_schema;
Database changed
mysql> show grants;
+---------------------------------------------------------------------+
| Grants for root@localhost                                           |
+---------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION |
| GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION        |
+---------------------------------------------------------------------+
2 rows in set (0.00 sec)

mysql> show events;
ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database 'performance_schema'

Thank you for the bug report. Similar behavior was reported for information_schema
in the past http://bugs.mysql.com/bug.php?id=32775.

Noted in 5.7.6 changelog.

SHOW EVENTS in the performance_schema database returned an
access-denied error, rather than an empty result as is done for
INFORMATION_SCHEMA. Now an empty result is returned.