给mysql的root %用户添加grant权限和创建的用户权限

select user,host,grant_priv from user;   查看现有权限


update user set grant_priv='Y' where user='root';  赋予权限