Ok after spending 1/2 day here what I did : 1- Find Ambaris password location : shell> grep "password" /etc/ambari-server/conf/ambari.properties 2- The output from previous command: server.jdbc.user.passwd=/etc/ambari-server/conf/password.dat 3- Cat password.dat [root@sandbox-hdp conf]# cat /etc/ambari-server/conf/password.dat //output is 'bigdata' from this command 4- Enter Ambaris postgreSQL db bigdata[root@sandbox-hdp psql -U ambari Password for user ambari: psql (9.2.23) Type "help" for help. ambari=> 5- Execute the select: Expanded display is on. ambari=> select config_id,type_name,config_data from clusterconfig where type_name='hive-site' ORDER BY config_id DESC LIMIT 1; 6- From the output search for: "javax.jdo.option.ConnectionPassword":"hortonworks1" ... View more

I tried 'hadoop' password -> not working I tried sudo grep "temporary password" /var/log/mysqld.log -> not working I tried https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html and I ended up with https://stackoverflow.com/questions/25700971/fatal-error-please-read-security-section-of-the-manual-to-find-out-how-to-run -> not working Why on a sandbox I need a CIA/FBI hidden password for mysql ?! is it so important ? ANY OTHER IDEAS ? ... View more