Breaking News: Grepper is joining You.com. Read the official announcement!

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

Friendly Hawk answered on September 29, 2021 Popularity 9/10 Helpfulness 10/10

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

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

Comment

MySql Workbench 8 or above introduced this issue. To Fix:

Under Mysql Connections, Right Click Connection and "Edit Connection", 
Go to Advanced Tab, In Others Box add the line: OPT_LOCAL_INFILE=1

#reopen connection in workbench and rerun the load data command

Popularity 9/10 Helpfulness 10/10 Language sql

Source: Grepper

Tags: file load local request restrictions sql

Link to this answer
Share Copy Link

Contributed on Sep 29 2021

Friendly Hawk

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

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

Contents

More Related Answers

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

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.