select user,host from mysql.user;  查看用户@登陆主机表

show grants for hive_app@*.*.3.101; 查看用户登陆主机权限

GRANT USAGE ON *.* TO 'hive_app'@'*.*.3.101' IDENTIFIED BY 'zxcvbnm'  添加用户登陆远程主机登陆权限

flush privileges; 刷新

USAGE 只登陆无操作权限

select,insert,update,delete,create,drop,index,alter,grant,references,reload,shutdown,process,file等14个权限。

ALL PRIVILEGES 所有权限