#------------mysql root 用户无法赋权问题解决 --------

，登录  mysql -u root -p

，use mysql; 选择mysql数据库

，执行以下操作（查询用户的赋权权限，更改赋权权限 ，刷新生效）

mysql> select user,host,grant_priv from user;

+---------------+-----------+------------+

| user          | host      | grant_priv |

+---------------+-----------+------------+

| root          | localhost | Y          |

| mysql.session | localhost | N          |

| mysql.sys     | localhost | N          |

| root          | %         | N          |

| xc_admin      | %         | N          |

+---------------+-----------+------------+

 rows in set (0.00 sec)

mysql> update user set grant_priv='Y' where user = 'root';'

Query OK,  row affected (0.00 sec)

Rows matched:   Changed:   Warnings: 

mysql> flush privileges;#刷新权限

Query OK,  rows affected (0.00 sec)

mysql> select user,host,grant_priv from user;

+---------------+-----------+------------+

| user          | host      | grant_priv |

+---------------+-----------+------------+

| root          | localhost | Y          |

| mysql.session | localhost | N          |

| mysql.sys     | localhost | N          |

| root          | %         | Y          |

| xc_admin      | %         | N          |

+---------------+-----------+------------+

 rows in set (0.00 sec)