root用户登录mysql:
grant all privileges on *.* to hive@"localhost" identified by "hive" with grant option;
grant all privileges on数据库名称(*表示任意数据库).表名(*表示任意表) to 用户名@"ip地址(%表示任意ip都能登录)" identified by "密码" with grant option;
flush privileges//刷新用户权限
root用户登录mysql:
grant all privileges on *.* to hive@"localhost" identified by "hive" with grant option;
grant all privileges on数据库名称(*表示任意数据库).表名(*表示任意表) to 用户名@"ip地址(%表示任意ip都能登录)" identified by "密码" with grant option;
flush privileges//刷新用户权限