Support Questions
Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Innovation Accelerator group hub.

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

New Contributor
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 REPLIES 2

New Contributor

Had to run

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

New Contributor

Had to run

/usr/bin/mysql_secure_installation

and

changing root password

remove anonymous users - Yes

changing the option disallowing remote connection to "NO"