My OS is Ubuntu 18.04. On this OS the file path for MySql is
/etc/mysql/mysql.conf.d/mysqld.cnf
Edit this file and add:
[mysqld] # # * Basic Settings # secure-file-priv = "" local-infile [mysql] local-infile
On my system, the section [mysql] doesn't exists, so I added it at the end of the file:
Restart Mysql
sudo service mysql restart
Start the CLI:
mysql -uroot -p your_db_name
and issue this command:
SHOW GLOBAL VARIABLES LIKE 'local_infile';
The value should be set to ON.
Go back to Matomo system check and LOAD DATA INFILE should be green:
