How can I get LOAD DATA LOCAL INFILE to work for MySQL 8.0.21 on a Windows machine?


I’ve created a file: 'C:\fff.txt' which contains data for my database table. Then I’m trying to load data from that file like this:

LOAD DATA LOCAL INFILE 'C:\fff.txt' INTO TABLE fff LINES TERMINATED BY '\r\n';  

but I get the following error all the time:

ERROR 2 <HY000>: File 'C:\fff.txt' not found (OS errno 2 - No such file or directory) 

I’ve added local_infile=1 to [mysql] and [mysqld] sections of my.ini file. When I type: SHOW GLOBAL VARIABLES LIKE 'local_infile'; I can see that it’s set to 'ON'. Is there a way to solve this problem?