mysql插入数据报错怎么办

load data local infile "path/myfile.csv" into table table_name fields terminated by "," lines terminated by  "\r\n" ignore 1 lines;

ERROR 1148 (42000): The used command is not allowed with this MySQL version

SET GLOBAL local_infile=1;

mysql --local-infile=1 -u root -p

load data local infile "path/myfile.csv" into table table_name fields terminated by "," lines terminated by  "\r\n" ignore 1 lines;

Query OK, 2998533 rows affected, 65535 warnings (36.36 sec)

Records: 2998533  Deleted: 0  Skipped: 0  Warnings: 2998533