Access denied for user 'dbxxxxxx'@'%' to database 'dbxxxxxx' - in plugin Goals

Support & Bugs
1

Hi,

since the last update all cronjob are not working to archive the reports.
Also all outgoing links are not tracked.
If I user toe option “archive the report while using browser” i get this error message:
Access denied for user ‘dbxxxxxx’@’%’ to database ‘dbxxxxxx’ - in plugin Goals

Has anybody a idea to fix this?

Thanks

Ralf

2

Hi Ralf,

the solution might be to grant CREATE TEMPORARY TABLES permission to your DB user. Please see for example the GRANT query in How do I create a new database and database user in MySQL? FAQ - Analytics Platform - Matomo

we’ll hopefully make this error message more clear in the future When DB user doesn't have the 'CREATE TEMPORARY TABLE' grant, display a clear error message · Issue #15237 · matomo-org/matomo · GitHub