mysql:在information_schema 上拒绝访问 [英] mysql: access denied on information_schema

问题描述

当我创建新用户或向现有用户授予权限时，出现此错误:

When i'm create new user or grant privileges to existing, i got this error:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

在所有表上授予权限，除了information_schema，在这个表上我得到了访问被拒绝的错误.我该如何解决?转储所有数据库，删除所有数据库，然后从转储中恢复?

Grant privileges ok on all tables, except information_schema, on this table i got access denied error. How i can fix? Dump all databases, drop all databases, and then restore from dump?

推荐答案

MySQL 文档 说:

...您只能读取表的内容，不能对它们执行 INSERT、UPDATE 或 DELETE 操作.

... you can only read the contents of tables, not perform INSERT, UPDATE, or DELETE operations on them.

这篇关于mysql:在information_schema 上拒绝访问的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！