I am running on shared hosting and the hosting company runs MySQL on a different server from the one I'm running on. I want to create csv files using SELECT INTO OUTFILE and have the csv created in one of my passworded directories. I'm using the command shown in the snippet below and I get this error
#1045 - Access denied for user '<my database user name>' (using password: YES)
Is there a way to specify the UNIX DIRECTORY user and password?
INTO OUTFILE '/home/.../test.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
ESCAPED BY '\\'
LINES TERMINATED BY '\n'