How can I get LOAD DATA LOCAL INFILE to work for MySQL 8.0.21 on a Windows machine?
Windows restricts the acces for that folder.
Best is to create a separate folder and give it the right access rights.
I tried a lot but i can't replicate your message, when the file exists it can open it and insert the data.
so the basic steps
Open your my.ini file
and find, so put there the new created folder

&quot;c:/my_folder/&quot;

in double quotes
# Secure File Priv. 
secure-file-priv=&quot;C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/&quot;

restart your server
place there your fff.txt
Which should look like this
test
test
test
test
test
test

and then run
LOAD DATA INFILE 'c:/my_folder/fff.txt' INTO TABLE fff
LINES TERMINATED BY '\r\n'; 

and sex rows are inserted.