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' |
Attachments
Issue Links
Activity
| Field | Original Value | New Value |
|---|---|---|
| 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' |
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: {code:sql} 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' {code} |
| Component/s | Authentication and Privilege System [ 13101 ] | |
| Fix Version/s | 10.2 [ 14601 ] | |
| Affects Version/s | 5.5 [ 15800 ] | |
| Affects Version/s | 10.0 [ 16000 ] | |
| Affects Version/s | 10.1 [ 16100 ] | |
| Affects Version/s | 10.2 [ 14601 ] | |
| Assignee | Sergei Golubchik [ serg ] | |
| Labels | upstream-fixed |
| Remote Link | This issue links to "Bug #73082 SHOW EVENTS in performance_schema gives Access Denied (Web Link)" [ 28309 ] |
| Status | Open [ 1 ] | Confirmed [ 10101 ] |
| Fix Version/s | N/A [ 14700 ] | |
| Fix Version/s | 10.2 [ 14601 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Confirmed [ 10101 ] | Closed [ 6 ] |
| Resolution | Fixed [ 1 ] | |
| Status | Closed [ 6 ] | Stalled [ 10000 ] |
| Status | Stalled [ 10000 ] | In Progress [ 3 ] |
| Resolution | Not a Bug [ 6 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
| Workflow | MariaDB v3 [ 84508 ] | MariaDB v4 [ 153397 ] |