question Re: Deleting hive service on CDP Private Base and no clues for username and password in Support Questions

Deleting hive service on CDP Private Base and no clues for username and password

shofialau — Tue, 21 Apr 2026 06:31:42 GMT

I was deleted hive services with some tools (livy, hue, kudu, oozie, hive on tez) because I forgot to keep All of the password. Now I want to re-add services that I deleted. but I have no clue for this. I don't know username and password.

Please help

Re: Deleting hive service on CDP Private Base and no clues for username and password

smruti — Sun, 05 May 2024 20:27:47 GMT

@shofialau First of all, you could always create a new database and user for Hive, and all other services.

Refer to step 7 of https://docs.cloudera.com/cdp-private-cloud-base/7.1.8/hive-metastore/topics/hive-mysql_.html

If you want to reuse the existing DB and user, you should be able to reset the user password in mysql.

Connect to mysql as root user, and run the command as follows:

UPDATE mysql.user SET authentication_string = PASSWORD('new_password') WHERE User = 'hive' AND Host = 'metastorehost';

In case you are not sure, or you do not have root privileges, this can be reset as well:

ref: https://dev.mysql.com/doc/refman/8.0/en/resetting-permissions.html

Re: Deleting hive service on CDP Private Base and no clues for username and password

shofialau — Tue, 07 May 2024 04:32:55 GMT

Hi thanks for answering.
But i still get stuck.
How do I install JDBC driver? should I install from Cloudera Documentation?

Re: Deleting hive service on CDP Private Base and no clues for username and password

smruti — Tue, 07 May 2024 14:55:20 GMT

@shofialau Let's not get confused with that JDBC driver mentioned in the doc. We can ignore that for now.

We have two options relating to the metastore DB situation.

Recover the password of the hive metastore DB user.
Create a new database and user.

I had shared the command to reset the DB user password(Option - 1) , or if you plan to create a new database(option -2), try the following commands:

mysql> CREATE DATABASE hmsdb; mysql> CREATE USER 'hiveuser'@'metastorehost' IDENTIFIED BY 'mypassword'; mysql> REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'hiveuser'@'metastorehost'; mysql> GRANT ALL PRIVILEGES ON hmsdb.* TO 'hiveuser'@'metastorehost'; mysql> FLUSH PRIVILEGES; mysql> quit;

Replace the "metastorehost" with the Hive metastore node hostname.

Re: Deleting hive service on CDP Private Base and no clues for username and password

shofialau — Wed, 08 May 2024 06:23:28 GMT

I already create this:

mysql> create database hmsdb; Query OK, 1 row affected (0.01 sec) mysql> CREATE USER 'swg_mysql'@'cdp-utility.swgemilang.com.local' IDENTIFIED BY 'xxxxx'; Query OK, 0 rows affected (0.01 sec) mysql> REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'swg_mysql'@'cdp-utility.swgemilang.com.local'; Query OK, 0 rows affected (0.00 sec) mysql> GRANT ALL PRIVILEGES ON hmsdb.* TO 'swg_mysql'@'cdp-utility.swgemilang.com.local'; Query OK, 0 rows affected (0.01 sec) mysql> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec)

but it still like this:

Re: Deleting hive service on CDP Private Base and no clues for username and password

smruti — Wed, 08 May 2024 13:03:33 GMT

@shofialau great! Now we can download mysql jdbc connector and place in the HMS node under the location /usr/share/java

Detailed information can be found here - https://docs.cloudera.com/cdp-private-cloud-upgrade/latest/upgrade-hdp/topics/amb-install-mysql-jdbc.html#pnavId2