對於performance_schema庫show events時報 1044

psufnxk2000發表於2015-05-12
ORM
網友遇到這個問題： 
對於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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章