Bug #80164 Error Code 1290 No way around this!
Submitted: 27 Jan 2016 0:34 Modified: 27 Jan 2016 1:06
Reporter: Roger Dysvick Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:6.3.6 OS:Windows (Microsoft Windows 7 Ultimate Service Pack 1)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[27 Jan 2016 0:34] Roger Dysvick
Description:
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\SlyFox\AppData\Roaming\MySQL\Workbench\log\wb.log]

Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement. There is no way to turn this off! There isn't a way to get around it either! Commenting it out does not work. Using a directory set for the output does not work, setting default DOES NOT WORK!! I am an individual, not a company and I am the administrator! If I want my computer to stand up and dance or light itself on fire that is my decision! Please fix this!!!
I have evry setting for myself set to allow for schemas and server admin.

How to repeat:
Easy, just try entering "LOAD DATA INFILE" and it happens every time!

Suggested fix:
Remove this unnecessary setting!
[27 Jan 2016 0:44] Roger Dysvick
This actually renders the product unusable! So it is "Serious" not just a performance issue.
[27 Jan 2016 1:06] Roger Dysvick
Changed to make it read "LOCAL" file and then it works. Did my research a little late, sorry.