Author: Razvan MIHAIU
razvan_rem@rem_mihaiu.name (please remove '_rem' and 'rem_')
From: www.mihaiu.name
Date: 28/08/2019

Matomo: how to enable LOAD DATA INFILE for mysql 5.7




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:

Sample MySql Config

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:










Best regards,
Razvan MIHAIU



Razvan Mihaiu � 2000 - 2019 european patent