topic A.A.A.R. install using mysql user other than root in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/a-a-a-r-install-using-mysql-user-other-than-root/m-p/49629#M19113 <HTML><HEAD></HEAD><BODY><P>Hello everyone,<BR />I am trying to install A.A.A.R. with mysql cluster.<BR />For some reasons, I am not allowed to use root for mysql, so I created another mysql user=pentahouser that has full permission to database AAAR_DataMart and AAAR_Kettle.<BR />According to&nbsp;this page (http://fcorti.com/alfresco-audit-analysis-reporting/aaar-how-to-install/aaar-install/) , I pressed INSTALL A.A.A.R. button, the log in catalina.out showed that</P><P></P><P>Access denied for user 'pentahouser'@'%' to database 'mysql'</P><P></P><P>It looks like it needs permission to 'mysql' database. <BR />Does anyone know what it reads/writes to 'mysql' database?<BR />or do I need more permissions on the other databases?</P></BODY></HTML> Thu, 07 Feb 2019 11:57:55 GMT thomasgk 2019-02-07T11:57:55Z A.A.A.R. install using mysql user other than root https://connect.hyland.com/t5/alfresco-forum/a-a-a-r-install-using-mysql-user-other-than-root/m-p/49629#M19113 Hello everyone,I am trying to install A.A.A.R. with mysql cluster.For some reasons, I am not allowed to use root for mysql, so I created another mysql user=pentahouser that has full permission to database AAAR_DataMart and AAAR_Kettle.According to&nbsp;this page (http://fcorti.com/alfresco-audit-analysis Thu, 07 Feb 2019 11:57:55 GMT https://connect.hyland.com/t5/alfresco-forum/a-a-a-r-install-using-mysql-user-other-than-root/m-p/49629#M19113 thomasgk 2019-02-07T11:57:55Z Re: A.A.A.R. install using mysql user other than root https://connect.hyland.com/t5/alfresco-forum/a-a-a-r-install-using-mysql-user-other-than-root/m-p/49630#M19114 <HTML><HEAD></HEAD><BODY><P>Hi Thomas.</P><P>Which version of AAAR/Pentaho are you using?</P><P>As you are imagining this issue is related to the&nbsp;authentication/authorization for sure, but we need to understand in which task exactly.</P></BODY></HTML> Sun, 10 Feb 2019 21:25:57 GMT https://connect.hyland.com/t5/alfresco-forum/a-a-a-r-install-using-mysql-user-other-than-root/m-p/49630#M19114 fcorti 2019-02-10T21:25:57Z Re: A.A.A.R. install using mysql user other than root https://connect.hyland.com/t5/alfresco-forum/a-a-a-r-install-using-mysql-user-other-than-root/m-p/49631#M19115 <HTML><HEAD></HEAD><BODY><P>Hi Francesco,<BR />Here is the version of AAAR/Pentaho I am using.</P><P></P><P>AAAR-Alfresco-CE-v5.1-Repository-v4.5<BR />pentaho-server-ce-7.0.0.0-25</P></BODY></HTML> Mon, 11 Feb 2019 04:18:13 GMT https://connect.hyland.com/t5/alfresco-forum/a-a-a-r-install-using-mysql-user-other-than-root/m-p/49631#M19115 thomasgk 2019-02-11T04:18:13Z Re: A.A.A.R. install using mysql user other than root https://connect.hyland.com/t5/alfresco-forum/a-a-a-r-install-using-mysql-user-other-than-root/m-p/49632#M19116 <HTML><HEAD></HEAD><BODY><P>Is there any reason for not using the latest Alflytics version?</P><P><BR /><A class="link-titled" href="http://fcorti.com/alflytics/" title="http://fcorti.com/alflytics/" rel="nofollow noopener noreferrer">Alflytics - The Open Source Business Intelligence solution over Alfresco - Francesco Corti</A>&nbsp;</P><P></P><P>I mean, I usually recommend to use the latest (and the greatest).</P></BODY></HTML> Mon, 11 Feb 2019 14:10:34 GMT https://connect.hyland.com/t5/alfresco-forum/a-a-a-r-install-using-mysql-user-other-than-root/m-p/49632#M19116 fcorti 2019-02-11T14:10:34Z