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
• Status: Closed
• 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

Description:
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
or
local-infile = 1

if you want to disable it:

local_infile = 0
or
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

Fixed.

[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.