In Administration > System Check, I see the following warning under Database abilities:
LOAD DATA INFILE
Using LOAD DATA INFILE will greatly speed Matomo’s archiving process up. To make it available to Matomo, try updating your PHP & MySQL software and make sure your database user has the FILE privilege.
If your Matomo server tracks high traffic websites (eg. > 100,000 pages per month), we recommend to try fix this problem.
Error: LOAD DATA INFILE failed… Error was:
Try #1: LOAD DATA INFILE : SQLSTATE: Invalid authorization specification: 1045 Access denied for user ‘U3363712’@‘192.168.4%’ (using password: YES),
Try #2: LOAD DATA LOCAL INFILE : SQLSTATE: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version
Troubleshooting: FAQ on matomo.org
I contacted my hosting company and they confirmed that the LOAD DATA INFILE command has been disabled due to security concerns, but they offered me a somewhat convoluted work around to reactivate it on a per request basis (using
My question: is it worth it? My combined sites don’t come close to 1,000,000 views per month. Can I ignore this error, or is it worth investing the time to get it fixed?