hive使用过程中对mysql授权问题

授权：

1.mysql> grant all privileges on *.* to root@'%' identified by '123456';

2.mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'WITH GRANT OPTION ;

3.mysql>flush privileges;

删除授权：

mysql>delete from mysql.user where user="root" and host="%";