对于performance_schema库show events时报 1044

网友遇到这个问题: 
对于performance_schema库show events时报 1044 

mysql> 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 
mysql> show events; 
ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database 'performance_schema' 

mysql> show grants for 'root'@'localhost'; 
+---------------------------------------------------------------------+ 
| 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> use test; 
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 
mysql> show events; 
Empty set (0.00 sec) 


这个问题有点怪 
原来是: 
https://bugs.mysql.com/bug.php?id=32775 
Bug #32775 problems with SHOW EVENTS and Information_Schema 


转载请注明源出处
请使用浏览器的分享功能分享到微信等