对于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 


转载请注明源出处

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25099483/viewspace-1650884/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25099483/viewspace-1650884/