Can't Create/write to file

1.1k views Asked by At

I'm new to coding and I am having trouble I think granting permission. I am trying to write an SQL statement to list the contents of the orders table and send the output to a file that has a .csv extension. But I keep getting this error:

enter image description here

1

There are 1 answers

0
Kazi Mohammad Ali Nur Romel On

I am not an expert on what you are asking but found below solution through google:

Try the following:

  1. mkdir /var/lib/mysql/tmp
  2. chmod mysql:mysql /var/lib/mysql/tmp
  3. Add the following line into the [mysqld] section: tmpdir = /var/lib/mysql/tmp
  4. Restart the server