Skip to content
Advertisement

Response like that `Error Code: 2068. LOAD DATA LOCAL INFILE file request rejected due to restrictions on access.’ When I load the data from CSV

When I run the code below in MySQL5.0, I will have a response like:

Error Code: 2068. LOAD DATA LOCAL INFILE file request rejected due to restrictions on access.

I already set the local infile to On, but still not working, do I need to still change any parameter?

Advertisement

Answer

OK, I found the solution finally, we need to go to the MySQL Command Line Client (My version is 5.7), and change all the in the path to /, like

In the workbench and cell will show us the different error, in the cell, the response is Error 1148, in the workbench is 2068.

User contributions licensed under: CC BY-SA
1 People found this is helpful
Advertisement