I'm trying to load a csv file into mysql using the Load Data Local Infile command in the mysql workbench and I'm getting the errror.
ERROR 1148 (42000): The used command is not allowed with this MySQL version
I added the local-infile=1 line to the my.cnf file, but continue to get the error. Do I need to do something else to be able to load a csv file? Is there a better way to load csv files into msql? Thanks.