grant all on dbname.tablename to ‘newuser’@‘%’ identified by ‘newuser123’; //拥有所有权限
grant select on dbname.tablename to ‘newuser’@‘%’ identified by ‘newuser123’; //拥有查询权限
grant update on dbname.tablename to ‘newuser’@‘%’ identified by ‘newuser123’; //拥有修改权限
grant select,update on dbname.tablename to ‘newuser’@‘%’ identified by ‘newuser123’; //拥有修改&c查询权限
设置增删改查权限类似,每个权限之间用逗号隔开即可,