mysql报错：ERROR1044、ERROR1227

当需要访问innodb.locks数据时:

select * from innodb.locks;

报错：error 1227（42000）：Access denied; you need (at least on of) the PROCESS privilege(s) for this operation

 

通过如下方式赋权

grant select on information_schema.* to 'user'@'%';

报错：error 1044 （42000）：Access denied for 'user'@'localhost' to database 'information_schema'

 

解决方法：

grant process on *.* to 'user'@'%';