Bug #109488 ERROR 2068 (HY000): LOAD DATA LOCAL INFILE file request rejected due to restrict
Submitted: 27 Dec 2022 7:50 Modified: 27 Dec 2022 12:37
Reporter: Bhakya S Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S2 (Serious)
Version:8.0.29 OS:Any
Assigned to: CPU Architecture:Any
Tags: ERROR 2068 (HY000): LOAD DATA LOCAL INFILE file request rejected due to restrict

[27 Dec 2022 7:50] Bhakya S 
Description:
Hi,

I have tried using the query to load the csv file into database but shows rejected due to restrictions on access.
Query is : load data local infile 'D:/testingdata.csv' into table RCM_testing.testtable fields Terminated by ',' Optionally enclosed by '"' Lines Terminated by '\n' Ignore 1 Rows;

But I need to load the testingdata csv file into 'testtable' table.

How do I fix it?

Error: ERROR 2068 (HY000): LOAD DATA LOCAL INFILE file request rejected due to restrictions on access.

How to repeat:
Hi,

I have tried using the query to load the csv file into database but shows rejected due to restrictions on access.
Query is : load data local infile 'D:/testingdata.csv' into table RCM_testing.testtable fields Terminated by ',' Optionally enclosed by '"' Lines Terminated by '\n' Ignore 1 Rows;

But I need to load the testingdata csv file into 'testtable' table.

How do I fix it?

Error: ERROR 2068 (HY000): LOAD DATA LOCAL INFILE file request rejected due to restrictions on access.
[27 Dec 2022 10:09] Bhakya S 
Hi,

Even I've checked the global local_infile is turned on or off, but it's turned on.
How to fix it? Because I need to resolve it as soon as possible.
[27 Dec 2022 12:37] MySQL Verification Team 
Hello Bhakya,

Thank you for the bug report.
Imho this is duplicate of Bug #91891, please see Bug #91891 and follow the suggested fix.

Regards,
Ashwini Patil