https://community.cloudera.com/t5/Support-Questions/Ranger-install-failure-due-to-mysql-login/m-p/205158#M167144 <P></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="16219-ranger-failure.jpg" style="width: 1016px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/17128iCD77A2EB1628B8DE/image-size/medium?v=v2&amp;px=400" role="button" title="16219-ranger-failure.jpg" alt="16219-ranger-failure.jpg" /></span></P>Ranger creates the database and usernames successfully by fails on granting privileges ? <P>please take a look at screenshot.</P> Sun, 18 Aug 2019 04:54:02 GMT aliyesami 2019-08-18T04:54:02Z https://community.cloudera.com/t5/Support-Questions/Ranger-install-failure-due-to-mysql-login/m-p/205158#M167144 <P></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="16219-ranger-failure.jpg" style="width: 1016px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/17128iCD77A2EB1628B8DE/image-size/medium?v=v2&amp;px=400" role="button" title="16219-ranger-failure.jpg" alt="16219-ranger-failure.jpg" /></span></P>Ranger creates the database and usernames successfully by fails on granting privileges ? <P>please take a look at screenshot.</P> Sun, 18 Aug 2019 04:54:02 GMT https://community.cloudera.com/t5/Support-Questions/Ranger-install-failure-due-to-mysql-login/m-p/205158#M167144 aliyesami 2019-08-18T04:54:02Z https://community.cloudera.com/t5/Support-Questions/Ranger-install-failure-due-to-mysql-login/m-p/205159#M167145 <P>This one is resolved , the solution was to </P><P>grant all privileges on *.* to <A href="mailto:'root'@'hiveserver'">'root'@'hiveserver'</A> identified by 'hadoop' with grant option;</P> Sun, 11 Jun 2017 14:09:14 GMT https://community.cloudera.com/t5/Support-Questions/Ranger-install-failure-due-to-mysql-login/m-p/205159#M167145 aliyesami 2017-06-11T14:09:14Z