problem to import load data infile
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



restart the MySQL server.