FAILED: SemanticException org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeExcepti

hive 启动 或者做增删该查时，如果报错

FAILED: SemanticException org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient

是因为mysql没有启动权限

先查看vi /etc/hosts

[root@sure hadoop]# vi /etc/hosts

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.236.128 sure

再查看hostname：

[root@sure hadoop]# hostname
sure

都正确。

尝试启动mysql

[root@sure hadoop]# mysql -u root -p

Enter password: 输入密码   进入后

mysql> GRANT ALL PRIVILEGES ON *.* TO 'hadoop'@'sure' IDENTIFIED BY 'hadoop' WITH GRANT OPTION;   

Query OK, 0 rows affected (0.25 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.08 sec)

再次使用hive即可。