MySQL output file location - accessing server files
If this is a one-time thing, you can do the following to export the result into csv file using MySQL workbench:

SELECT * FROM mytable


then the result will appear in the result table (area) all you need to do use export button in that area:



Otherwise, if you want to create output file you can do it by using a shared folder:


if its over a network //my_pc/folder/test.csv that both machines have read/write access 
and if its under the same server use for example d:/test.csv 


and save the file into any location you want.