how to check hive meta store db's password?

[#1]

I am using CM 5.14.2, and from hive's configuration page, i can see the value for javax.jdo.option.ConnectionUserName, which is used to access the underneath metastore db like mysql, but i can't see the value of javax.jdo.option.ConnectionPassword (which is display as **** in the page).

i have forgotten the password used to access hive metastore db. Is there any way to find it back?

[#2]

@michaelli Not from the UI.  You will need to go back to the actual metastore server and see the command(s) to create the hive user. If it’s a MySQL metastore it’s easy to go to MySQL prompt and arrow up to see previously executed commands with the hive user and password.  

[#3 · Accepted solution]

@michaelli 

You can use the CM API to fetch the service configurations by executing below command from terminal

# curl -u admin_uname:admin_pass "http://cm_server_host:7180/api/v19/cm/deployment"

The password should be present under the name : 

hive_metastore_database_password

Refer:

https://docs.cloudera.com/documentation/enterprise/5-14-x/topics/cm_intro_api.html#concept_dnn_cr5_m...

Hope this helps,

Paras

Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.