export or outfile the remote query result in my local computer

Hi,

I have connected to remote computer and tried to do "into outfile" but the file generated in remote computer not in my computer.I wonder whether i can export or outfile the remote query result in my local computer and how to make it.

There is no

SELECT ... INTO LOCAL OUTFILE

.

Well you can just use a query tab for a simple SELECT * FROM yourtable, and then use the "Export grid rows" menu item.

I am aware of the export function via the UI but I want to run the query daily, the CSV is powering a report. I am getting a SQL Error (1045): Access denied for user So is my syntax correct and it is a pure issue of privileges?

SELECT * from table_name where insert_timestamp > CURDATE() INTO OUTFILE 'C:\my_report.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';