Thanks Sagar and Ryad. I changed mysql root password to 'hortonworks1', then hive metastore started working. After that i can change ambari dashboard->hive->configs->advanced password change (before that it was grayed out cannot change the password). Another point when i change the password in ambari->hive, i need to change root password in mysql login also. ... View more

After mysql root password changed, hive metastore service not works. Before password change it worked. When I start the service i get below error SQLException : SQL state: 28000 java.sql.SQLException: Access denied for user 'root'@'sandbox-hdp.hortonworks.com' (using password: YES) ErrorCode: 1045 2018-08-30 17:13:22,761 [E] Can't establish db connection. , After reset mysql root password , hive metastore and ranger admin not works (before changing MySQL root password the hive service was working). Below error shows SQLException : SQL state: 28000 java.sql.SQLException: Access denied for user 'root'@'sandbox-hdp.hortonworks.com' (using password: YES) ErrorCode: 1045 2018-08-30 17:13:22,761 [E] Can't establish db connection. ... View more