I write a MySQL table into an output file (working on Unix) but I can not enter the file directory (permission denied)

When I output a whole table into an output file named 'Arshan.txt' this command works well but I can not access the开发者_开发技巧 output file created. When I access /usr/local/mysql/data it says permission denied. Any help will be appreciated.

You'll need to access the file using the same account the MySQL process is running under. If you're an administrator on the machine you can also use sudo to execute any command with superuser privileges. For example:

sudo cp /usr/local/mysql/data/Arshan.txt ~foo/Arshan.txt
sudo chown foo ~foo/Arshan.txt