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:
None 
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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.061 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.