Bug #55031 Workbench can't enable/disable local_infile (LOAD DATA LOCAL)
Submitted: 6 Jul 2010 16:16 Modified: 13 Dec 2010 16:46
Reporter: Tommy Tremblay Email Updates:
Status: Closed Impact on me:
Category:MySQL Workbench: Administration Severity:S3 (Non-critical)
Version:5.2.24, 5.2.25 OS:Any (2008R2 with MySQL 5.1.48, Mac OS X)
Assigned to: Maksym Yehorov CPU Architecture:Any
Tags: disable, enable, load data local, local-infile, MySQL, workbench

[6 Jul 2010 16:16] Tommy Tremblay
It is impossible to enable or disable local_infile (LOAD DATA LOCAL) with Workbench.

How to repeat:
Open Workbench, go to ---> Server Administration ---> Configuration ---> Security ---> "Enable load data local infile".  By default, this option is "On" in MySQL, but it won't be checked in Workbench, because is it not reading the proper value:

local-infile instead of local_infile

and unchecking "Enable load data local infile" then apply will remove local-infile = instead of local_infile = 0.  So it will not be disable.

Suggested fix:
Open my.ini, then;

if you want to enable it (it is on by default anyway...)

local_infile = 1
local-infile = 1

if you want to disable it:

local_infile = 0
local-infile = 0

And one should think of removing either local-infile or local_infile.
[6 Jul 2010 17:21] MySQL Verification Team
Do you have older my.ini file from older/removed installations?. Thanks in advance.
[6 Jul 2010 20:43] Tommy Tremblay
I took the my.ini from v5.1.48 zip files (my-huge.ini)
[7 Jul 2010 4:09] Valeriy Kravchuk
Thank you for the bug report. Verified with 5.2.25 on Mac OS X also.
[7 Jul 2010 16:50] Alfredo Kojima
This seems like a duplicate of bug #54933
[7 Jul 2010 16:55] Tommy Tremblay
I would say no, because it will be impossible to disable local-infile even if the underscore isn't used because WB remove the line instead of inserting the line local-infile = 0.
[8 Jul 2010 17:00] Maksym Yehorov
[22 Oct 2010 15:40] Maksym Yehorov
Fixed setting/clearing of default true options, including local-infile.
[8 Dec 2010 22:37] Johannes Taxacher
fix confirmed in repository
[13 Dec 2010 16:46] Tony Bedford
An entry has been added to the 5.2.31 changelog:

In the Configuration tab of the Administrator it was not possible to enable or disable the local_infile (LOAD DATA LOCAL) option.