MySQL Bugs: #17921: security setting from MySQL Administrator does not work

Bug #17921	security setting from MySQL Administrator does not work
Submitted:	5 Mar 2006 0:43	Modified:	8 Sep 2006 10:49
Reporter:	Peter Laursen (Basic Quality Contributor)	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Administrator	Severity:	S2 (Serious)
Version:	1.1.9	OS:	Windows (WinXP - probably any)
Assigned to:	Vladimir Kolesnikov	CPU Architecture:	Any
Tags:	Server Configuration

Description:
On the 'security tab'  the 'enable load local data infile' does not write correctly to configuration file.

Checking the box first time inserts (literally) "local-infile" .
Unchecking commments the line to read like "#local-infile"

Correct is "local-infile = 1" and "local-infile = 0" respectively 
according to http://dev.mysql.com/doc/refman/5.1/en/privileges-options.html

I only checked this option, but I would be surprised if it was not the same with more of them!

How to repeat:
Start MySQLadministrator, check the option, save, next uncheck it and save.
Restart server

You would now expect that "load data local infile ..." did not import and raised an error

but any valid "load data local infile ..." imports!

because my.ini contains "# local-infile"

Suggested fix:
The easy fix:

Omitting the option seems to be the same as "local-infile = 1", so inserting "local-infile = 0" with CHECK and commenting with UNCHECK would work I think.

what I wrote:

Suggested fix:
The easy fix:

Omitting the option seems to be the same as "local-infile = 1", so inserting
"local-infile = 0" with CHECK and commenting with UNCHECK would work I think.

.. of course will need to change display in MA from 'enable' to 'disable'

Thank you for a bug report. Verified just as described.

Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html