Bug #92805 Can't use the LOAD DATA LOCAL INFILE and LOAD DATA LOCAL INFILE commands
Submitted: 16 Oct 2018 20:28 Modified: 17 Oct 2018 7:36
Reporter: Nicolas Robin Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.7.23 OS:MacOS (version 10.14 - Mojave)
Assigned to: CPU Architecture:x86 (64 bits)

[16 Oct 2018 20:28] Nicolas Robin 
Description:
I can't use the LOAD DATA LOCAL INFILE and LOAD DATA LOCAL INFILE commands with MySQLWorkbench 8.0.12 build 13312926 CE (64 bits) Community

I keep getting this type of error :

22:14:51	
LOAD DATA LOCAL INFILE '/Applications/clients3.txt'  
INTO TABLE clients  
FIELDS TERMINATED BY ';'  
LINES TERMINATED BY '\r'  IGNORE 1 LINES

Error Code: 1148. The used command is not allowed with this MySQL version	0.00019 sec

And FYI...

SHOW GLOBAL VARIABLES LIKE 'local_infile';
returns :

22:16:59
SHOW GLOBAL VARIABLES LIKE 'local_infile'	1 row(s) returned	0.0012 sec / 0.0000079 sec
--> 'local_infile','ON'

How to repeat:
It is 100% reproducible.
[16 Oct 2018 20:39] Nicolas Robin 
Mamp indicates that the MySQL active version is : 5.7.23.
[16 Oct 2018 21:30] MySQL Verification Team 
Thank you for the bug report. Duplicate of bug? https://bugs.mysql.com/bug.php?id=91891.
[17 Oct 2018 7:36] Nicolas Robin 
It is definitely a duplicate bug report. Sorry about that.
You can close this report if you want.
Please confirm this is a defect and make sure I am notified when the bug is fixed.
Best regards,
Nicolas Robin