I'm trying to create a csv export of data from mysql using the following query:
SELECT * INTO OUTFILE '/tmp/result.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\n' FROM getfreepellets WHERE 1
And I get the following error:
#1045 - Access denied for user '[username]'@'localhost' (using password: YES)
(removed username but it's the right one)
How would I go about granting access to this user to create a file on the server?
I changed the first line to be my exact home path, and received the same error.