Hello all,
I’m trying to import GA data into Matomo with the Command line. Everything seems to work well but I keep having :
Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user ‘my_username’@’%’ (using password: YES)[28000],
Try #2: LOAD DATA LOCAL INFILE
For instance, when I do this command : php ./console googleanalyticsimporter:import-reports --property=UA-XXXXXX-X --view=XXXXXXXX --dates=2015-01-01,2022-08-01 it process to the import but I have the message above for each date of the period I set in the command.
However, when the process it’s done, I can find the datas in the site id of my Matomo Dashboard.
Is those messages are important? Is there a way to solve this? I read so many articles about this but none of them solved my problem. ( I use the self hosted option and I give admin permission to the username)
Many many thanks for helping me!
Al the best