how to check hive meta store db's password?

Question

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?

paras · Accepted Answer

@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_mr__section_ztf_lyt_xr

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.

stevenmatison · Answer

@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.

Sign up

Please use your Cloudera account.

Login to the community

Please use your Cloudera account.