https://community.cloudera.com/t5/Support-Questions/Error-starting-HIVE-metastore/m-p/209324#M171278 <P><EM><A href="@Harry Li"> @Harry Li</A><BR /></EM></P><P><EM>Do the following as root create the hive user with the following privileges</EM></P><PRE>mysql -u root -h localhost Create user hive identified by 'hive'; grant all on hive.* to hive; GRANT ALL PRIVILEGES ON hive.* TO 'hive'@'localhost' IDENTIFIED BY 'hive'; GRANT ALL PRIVILEGES ON hive.* TO 'hive'@'&lt;FQDN_of_Mysql&gt;'IDENTIFIED BY 'hive'; flush privileges; quit; </PRE><P><EM>As the hive user with the assumption, here <STRONG>database,user</STRONG> and <STRONG>password</STRONG> are <STRONG>hive </STRONG> for simplicity </EM></P><PRE>mysql -u hive -phive create database hive; show databases; quit;</PRE><P><EM>Now use these credentials for setting up the hive database and user n Ambari user and test connection to the hive database, it should succeed before you can successfully start hive !!</EM></P> Thu, 02 Aug 2018 03:34:45 GMT Shelton 2018-08-02T03:34:45Z