problem to import load data infile

Question

I am trying to load data into mysql database form text file.

LOAD DATA LOCAL INFILE 'P:\file.txt' INTO TABLE table_january
FIELDS TERMINATED BY '\t'
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS

error code: 1148. The used command is note allowed with this MySQL

MySQL version 8.0.19.

Answer 1

looks like this an issue with mysql workbench 8 . Try this workaround.
1. locate or create your my.cnf file. E.g. if you're on a unix platform, look for ~/.my.cnf and create it if it doesn't exist.
2. update my.cnf to contain

[client]
port        = 3306
[mysqld]
port        = 3306
secure_file_priv=''
local-infile = 1

3. restart the MySQL server.