MySQL root用户不能为普通用户赋权限

mysql> select host,user,password,Grant_priv,Super_priv FROM mysql.user;
+--------------+---------+-------------------------------------------+------------+------------+
| host         |   user     | Grant_priv | Super_priv |
+--------------+---------+-------------------------------------------+------------+------------+
| 192.168.10.% | zzh   | N          | Y          |
| 192.168.10.% | he    | N          | Y          |
| 192.168.10.% | root  | Y          | Y          |
| localhost    | sdvv  | N          | N          |
| localhost    | root  | Y          | Y          |
| %            | root  | N          | Y          |
| 127.0.0.1    | root  | Y          | Y          |
| %            | sdvv  | N          | Y          |
+--------------+---------+-------------------------------------------+------------+------------+

 %            | root  | N   

update mysql.user set Grant_priv='Y', Super_priv='Y' where User='root';
flush privileges;