openSUSE Thumbleweed VM, 4GB RAM, 2 CPU, 30GB HDD (10GB free) on top of EXSi 6

According to the screenshot, in your LOAD statement you don't actually specify the path to the file, so the server has no way knowing you are trying to load from the secure folder, hence the error.
The screenshot does not show statements that you used for Connect XML tables, so I can't say anything about those.

I thought that there was no need to specify the file path if stored in the directory pointed by secure_file_priv.

Anyway I have tried both with and without the path and it fails. Here is the SQL code excerpt I just ran and failed:

use test_memory;

– need big heap tables
set max_heap_table_size=1024*1024*1024;

– table to hold test results
create table if not exists results (
id serial,
operation char(32),
opsize bigint unsigned,
started datetime,
ended datetime,
instance char(20)
);

drop table if exists t1;
create table t1 (c1 char(20), index (c1)) engine memory;
load data infile "/var/lib/mysql/hash2.txt" into table t1;
drop table t1;

ALso included a new screenshot. Hope this will help.

erchbox,

Anyway I have tried both with and without the path and it fails

In your code and in the screenshot you are trying to load the file from /var/lib/mysql, but in the previous screenshot and in the description the allowed location was /var/lib/mysql-files. Unless you reconfigured it since then, naturally it does not work.

I thought that there was no need to specify the file path if stored in the directory pointed by secure_file_priv.

Yes, there is the need. The value does not set the default path, it just restricts the allowed locations

Great eyes, thanks!

The example works flawlessly now.

One of the wonders of collaborating is that others can see what you can't.

Sorry for having wasted your precious time on my temporary blindness.

You can close the case.