Bug #103212 LOCAL_INFILE "OFF"
Submitted: 6 Apr 2021 1:14 Modified: 6 Apr 2021 6:36
Reporter: SAMUEL ADENIGBA Email Updates:
Status: Not a Bug Impact on me:
Category:MySQL Server Severity:S1 (Critical)
Version:8.0.23 OS:Windows
Assigned to: CPU Architecture:Any

[6 Apr 2021 1:14] SAMUEL ADENIGBA
I can not LOAD DATA LOCAL INFILE command via Workbench. It returns the following error:
	Error Code: 3948. Loading local data is disabled; this must be enabled on both the client and server sides	0.000 sec

then I ran this code to confirm if my local_infile is on or off

show variables like '%INFILE%';

then I got this:

local_infile off

pls how can I put it on?

How to repeat:
copy and paste
[6 Apr 2021 6:36] MySQL Verification Team
Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Please see https://dev.mysql.com/doc/refman/8.0/en/load-data.html
Quoting from manual - LOCAL works only if the server and your client both have been configured to permit it. For example, if mysqld was started with the local_infile system variable disabled, LOCAL produces an error and more here https://dev.mysql.com/doc/refman/8.0/en/load-data-local-security.html