Ranger configuration: ERROR: Unable to connect to the DB. Please check DB connection properties.

[#1]

java.sql.SQLException: Access denied for user 'root'@'namenode' (using password: YES)

select user,host,password from mysql.user;

| user | host | password |

| root | localhost | *B34D36DA2C3ADBCCB80926618B9507F5689964B6 |

| root | namenode |

| root | 127.0.0.1 |

| localhost |

| namenode |

| ranger | localhost | *B34D36DA2C3ADBCCB80926618B9507F5689964B6 |

| ranger | % | *B34D36DA2C3ADBCCB80926618B9507F5689964B6 |

[#2]

Had to run

/usr/bin/mysql_secure_installation and changing the option disallowing remote connection to "NO"

[#3]

Had to run

/usr/bin/mysql_secure_installation

and

changing root password

remove anonymous users - Yes

changing the option disallowing remote connection to "NO"