MySQL: MySQL Privileges needed for SELECT ... INTO OUTFILE

MySQL "FILE" Privilege is need to grant to the user, to execute SELECT ...INTO OUTFILE ..  

or 

LOAD DATA INFILE "/tmp/xxxx.csv" INTO .... 

or else, you will get 

Access denied for user 'test'@'%'  when you run the query