0

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.

2
0

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
  1. restart the MySQL server.
1
  • 1
    Link-only posts are discouraged; please see How to Answer. If you think one of the workarounds at your link is the solution, you are encouraged to explain it fully here with your own helpful additions & attribution. Welcome to the network :) – Peter Vandivier Feb 20 '20 at 11:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.