Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

how to check hive meta store db's password?

Highlighted

how to check hive meta store db's password?

New Contributor

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 REPLIES 2
Highlighted

Re: how to check hive meta store db's password?

Master Collaborator

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

 


 


If this answer resolves your issue or allows you to move forward, please choose to ACCEPT this solution and close this topic. If you have further dialogue on this topic please comment here or feel free to private message me. If you have new questions related to your Use Case please create separate topic and feel free to tag me in your post.  


 


Thanks,



Steven

Re: how to check hive meta store db's password?

Expert Contributor

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

Don't have an account?
Coming from Hortonworks? Activate your account here