access denied when trying to load data with mysql

I run into a permission error when trying to load data into mysql .

To read a file with LOAD DATA INFILE from the server, the user needs FILE privilege, and I don't think that's granted by default when you use "ALL" - grant that privilege and you should be fine.

For security reasons, when reading text files located on the server, the files must either reside in the database directory or be readable by all. Also, to use LOAD DATA INFILE on server files, you must have the FILE privilege. See Section 5.4.1, “Privileges Provided by MySQL”. For non-LOCAL load operations, if the secure_file_priv system variable is set to a nonempty directory name, the file to be loaded must be located in that directory.