Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL)
-
rhel 7
Description
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' |