1.查看所有用户,看是否存在这个用户
SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;
2.如果有,在赋予权限
EVOKE ALL PRIVILEGES, GRANT OPTION FROM ‘user’@'pass';
GRANT SELECT,INSERT,UPDATE,DELETE,LOCK TABLES,EXECUTE ON metastore.* TO‘user’@'pass';
3.在启动hive-metastore服务