With MySQL 8.X in order to execute "LOAD DATA LOCAL INFILE" you need to have local_infile = 1 in [mysqld] and loose-local-infile = 1 in [mysql] or [client]
Executing this command from MySQL client is ok:
LOAD DATA LOCAL INFILE '/home/cquiros/temp/GOBLET/build/GOBLET-createdb/test.csv' INTO TABLE climmob.testupload fields terminated by ',' lines terminated by '' (code,description);
LOAD DATA LOCAL INFILE '/home/cquiros/temp/GOBLET/build/GOBLET-createdb/test.csv' INTO TABLE climmob.testupload fields terminated by ',' lines terminated by '' (code,description);
To copy to clipboard, switch view to plain text mode
However in my Qt application with QSQLQuery.exec() I get:
LOAD DATA LOCAL INFILE file request rejected due to restrictions on access
It seems that in my Qt connection the database I need to set loose-local-infile = 1 but how to do it?
Bookmarks