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


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