mysql 授权用户cesuser 报错 1142 - SELECT command denied to user ‘root‘@‘localhost‘ for table ‘user‘

如果mysql  授权用户cesuser   报错 1142 - SELECT command denied to user 'root'@'localhost' for table 'user'
执行1-5即可


--1、查看root用户权限
show grants for root@'localhost';

--2、修改root用户权限
update mysql.user set Grant_priv="Y" where user="root" and host="%";

--3、提交
commit;

 --4、刷新权限
flush privileges;

--5、重启mysql服务

--创建用户oajk  密码 oajkoajk
6、create user oajk identified by 'oajkoajk';

--授权oajk用户增删改查ftoais.archivefound表权限
7、grant select,insert,update,delete on `ftoais`.`archivefound` to oajk@'%';