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
RE: 1148 - The used command is not allowed with this MySQL version. My guess is that you may be having a problem with mySQL-front rather than mysql the server. Malayalam folk songs download. I am a big fan of mySQL-front but use the menu items as an aide memoir only - if I have problems I resort to straight mysql commands in the editor. This version of the This system is not registered with RHN command is not allow command is not found used command is not allowed to co this is Not a crash This system is not r this class is not ke This device is not active The resource from this URL is not text This is life This is android！ This is OO This is My Life userinfo is not map not declared in this scope mysql version mysql version.