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

[23 Jun 2014 17:06] Alfredo Kojima
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'
[23 Jun 2014 20:36] MySQL Verification Team
Thank you for the bug report. Similar behavior was reported for information_schema
in the past http://bugs.mysql.com/bug.php?id=32775.
[28 Oct 2014 22:32] Paul DuBois
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.