请问各位大佬，mysql数据库创建一个巡检用户，需要能查information_schema。请问应该如何授权？
版本为mysql8，查询information_schema报错如下：
create user 'mymon'@'%' identified by 'tiger';
mysql> select * from INNODB_TABLES;
ERROR 1227 (42000): Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
mysql> grant process on information_schema.* to mymon@'%';
ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database 'information_schema'
查看用户权限
show grants;
查询指定用户权限
show grants for mymon@localhost;
授权要查询的库给mymon
grant select on test.* to mymon@localhost;
评论
有用 4创建用户之后create user 'mymon'@'%' identified by 'tiger';
需要赋权，grant select on information_schema.* to 'mymon'@'%' ;
评论 有用 0grant process on information_schema.* to mymon@'%';
改为如下：
grant process on *.* to mymon@'%';
process的授权，需要基于*.*，不能基于某一个schema或数据库来做。
评论 有用 08.0无法单独授予用户information_schema权限，但有一个投机取巧的办法，就是加一个转义字符杠，绕开校验的同时又保证授权有效：
GRANT SELECT ON `information\_schema`.* TO 'mymon'@'%';
另外PROCESS是全局权限，必须给*.* ：
GRANT PROCESS ON *.* TO 'mymon'@'%';
墨值悬赏