Solution to MySQL workbench error 1148 unable to load local data

Windows10 workbench 8.0 error code:1148 temporary solution is as follows :
1. In the Workbench, type Show Global variables like ‘local_infile’;
result should be :on. This problem has nothing to do with whether localinfile =1, which is a bug of workbench. 2. Continue to enter show variables like ‘secure_file_priv’;
the result should be C:\ProgramData\MySQL\MySQL Server 5.7\Uploads file; 3. Put the files that need to be imported into the file in step 2;
4. Load data local infile command to remove the local, and combined with step 2 folder path, for example, is as follows:
the load data infile ‘C:/ProgramData/MySQL/MySQL Server 5.7/Uploads/a.c sv into table a’;
Ps: resources: =91891 Post Catherine S reply, like one!

Read More: