https://community.cloudera.com/t5/Support-Questions/Error-starting-HIVE-metastore/m-p/209326#M171280 <P><A rel="user" href="https://community.cloudera.com/users/87334/harryli.html" nodeid="87334">@Harry Li</A>, you can grant access to hive user from any host.</P><P>Connect as a root user and run the below SQL statement.</P><OL> <LI>GRANT ALL PRIVILEGES ON hive.* TO 'hive'@'localhost' IDENTIFIED BY 'hive';</LI><LI>GRANT ALL PRIVILEGES ON hive.* TO 'hive'@'&lt;FQDN_of_Mysql&gt;'IDENTIFIED BY 'hive';</LI></OL><TABLE style="font-size: 15px;"><TBODY></TBODY></TABLE><P>More on that can be found at <A href="https://stackoverflow.com/questions/8348506/grant-remote-access-of-mysql-database-from-any-ip-address" target="_blank">https://stackoverflow.com/questions/8348506/grant-remote-access-of-mysql-database-from-any-ip-address</A></P> Thu, 02 Aug 2018 04:59:06 GMT apappu 2018-08-02T04:59:06Z