对于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
转载请注明源出处
对于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博客 ” ，链接：https://blog.itpub.net/25099483/viewspace-1650884/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
