hive local metastore

Access denied for user ‘APP’@’localhost’ (using password: YES)

Error Scenario: Unable to open a test connection to the given database  or Access denied for user ‘APP’@’localhost’ (using password: YES) This error message (Access denied for user ‘APP’@’localhost’) will be received while trying to connect hive service through MySQL local metastore.

Root Cause: When we don’t provide username (javax.jdo.option.ConnectionUserName) and password (javax.jdo.option.ConnectionPassword) configurations in hive-site.xml for accessing MySQL local metastore database we will receive this error message. By default these two […]