A.A.A.R. install using mysql user other than root

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

thomasgk

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 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

Access denied for user 'pentahouser'@'%' to database 'mysql'

It looks like it needs permission to 'mysql' database.
Does anyone know what it reads/writes to 'mysql' database?
or do I need more permissions on the other databases?

1549276730126.jpg

fcorti

Hi Thomas.

Which version of AAAR/Pentaho are you using?

As you are imagining this issue is related to the authentication/authorization for sure, but we need to understand in which task exactly.