The Used Command Is Not Allowed With This Mysql Version
In Matomo (#1 Free Web & Mobile Analytics Software) I get the error message:
LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MariaDB version[42000]
It is possible to activate LOAD DATA LOCAL INFILE?
LOAD DATA INFILE
Plesk 17.5.3 Update #53
MySQL v10.1.34
For the database user is in plesk a option
Global Privileges -> File with description 'Global privileges work for all databases within this hosting account'
When I activate this, I get error:
LOAD DATA INFILE : SQLSTATE[HY000]: General error: 13 Can't get stat of '/var/www/vhosts/example.com/.../tmp/assets/option-043...86.csv' (Errcode: 13 'Permission denied'),
LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MariaDB version[42000]
the CSV have permission 0777
I think this helps
MySQL :: MySQL 8.0 Reference Manual :: 6.1.6 Security Issues with LOAD DATA LOCAL
LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MariaDB version[42000]
It is possible to activate LOAD DATA LOCAL INFILE?
LOAD DATA INFILE
Plesk 17.5.3 Update #53
MySQL v10.1.34
For the database user is in plesk a option
Global Privileges -> File with description 'Global privileges work for all databases within this hosting account'
When I activate this, I get error:
LOAD DATA INFILE : SQLSTATE[HY000]: General error: 13 Can't get stat of '/var/www/vhosts/example.com/.../tmp/assets/option-043...86.csv' (Errcode: 13 'Permission denied'),
LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MariaDB version[42000]
the CSV have permission 0777
I think this helps
MySQL :: MySQL 8.0 Reference Manual :: 6.1.6 Security Issues with LOAD DATA LOCAL
Jeffrey, Sunday, July 28, 2002, 8:14:43 PM, you wrote: JAK Could you help me understand how to correct this error: JAK 'Error 1148: The used command is not allowed. Candyland ps4.