-1

Error Code: 3948. Loading local data is disabled; this must be enabled on both the client and server sides

show variables like 'event_scheduler'; // this is ON.

I saw a answer is set

OPT_LOCAL_INFILE=1;

but I did not find where can set it.

Ron
  • 5,900
  • 2
  • 20
  • 30
Shawn
  • 1
  • 1
    Does this answer your question? [ERROR: Loading local data is disabled - this must be enabled on both the client and server sides](https://stackoverflow.com/questions/59993844/error-loading-local-data-is-disabled-this-must-be-enabled-on-both-the-client) – Ron Jan 22 '23 at 23:47
  • Dose your MySQL server and client run on the same computer? – Kanakorn Horsiritham Jan 23 '23 at 00:34

1 Answers1

0

The file must be at the directory on the server. If you're using MySQL on Windows and the client is running in the same computer, it is no difference, but if your server is on the remote computer, you need the way to put the file in the server, not on the client directory.

Kanakorn Horsiritham
  • 98
  • 1
  • 7