Hive metastore issue in HDp2.3.4.0

[#1]

We have configured HDP 2.3.4.0 with Ambari in CentOS 6.4. Post installation we can see that the Hive Metastore service is getting stopped everytime it is started through Ambari. We had chosen MySQL for Hive metastore but in logs we can see it tries to connect with Derby. Looking for your help.

[#2]

@rajdip chaudhuri

Also, very important

Run following in mysql as root user

grant all privileges on *.* to 'hive'@'host' identified by 'hivepassword' with grant option;

[#3]

@rajdip chaudhuri

[#4]

@rajdip chaudhuri

Please go through the 2 attached install step by step methods it will help you resolve your problem

Please and let me know if all goes well