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 result set instead.
How to repeat:
MariaDB [(none)]> use performance_schema;
|
Reading table information for completion of table and column names
|
You can turn off this feature to get a quicker startup with -A
|
|
Database changed
|
MariaDB [performance_schema]> show grants;
|
+----------------------------------------------------------------------------------------------------------------------------------------+
|
| Grants for root@localhost |
|
+----------------------------------------------------------------------------------------------------------------------------------------+
|
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*****************************************' WITH GRANT OPTION |
|
| GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION |
|
+----------------------------------------------------------------------------------------------------------------------------------------+
|
2 rows in set (0.00 sec)
|
|
MariaDB [performance_schema]> show events;
|
ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database 'performance_schema'
|
Bug
Major
