Ranger DB connection test failing on ambari

[#1]

I am testing my ranger db connection on my sandbox it fails. I have not changed any password. using all defaults.

Traceback (most recent call last):

  File "/var/lib/ambari-agent/cache/custom_actions/scripts/check_host.py", line 477, in <module>
    CheckHost().execute()
  File "/usr/lib/python2.6/site-packages/resource_management/libraries/script/script.py", line 219, in execute
    method(env)
  File "/var/lib/ambari-agent/cache/custom_actions/scripts/check_host.py", line 212, in actionexecute
    raise Fail(error_message)
resource_management.core.exceptions.Fail: Check db_connection_check was unsuccessful. Exit code: 1. Message: ERROR: Unable to connect to the DB. Please check DB connection properties.
java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)

[#2 · Accepted solution]

@Sunile Manjee

This will fix it

grant all privileges on *.* to 'root'@'localhost' identified by 'password' with grant option;

[#3]

I found it the problem, it was the password. I issues the statement you gave and it still failed. Then I went into ambari and changed the password to password and it worked. thank you