获得 information_schema mysql 的权限

获得 information_schema mysql 的权限

问题描述:

如果我打开 MySQL Administrator 并尝试从数据库 information_schema 的表 events 中删除一个事件,我会收到此错误:

If I open MySQL Administrator and I try to delete one event from the table events of the database information_schema I get this error:

Access denied for user 'root'@'localhost' to database 'information_schema'

我需要什么权限?

information_schema 表都是只读的,无法删除任何行.

The information_schema tables are all read only, there is no way to delete any rows there.

要删除事件,请使用 DROP EVENT 语句.

To drop an event, use the DROP EVENT statement.