Go to advanced search

by cwc1911
Mon Jun 11, 2018 4:12 pm
Forum: General discussion
Topic: MySQL OUTFILE Errcode: 13 "Permission denied"
Replies: 3
Views: 7059

Re: MySQL OUTFILE Errcode: 13 "Permission denied"

mysql -u root -p CREATE USER 'ituser'@'localhost' IDENTIFIED BY 'mypass'; GRANT ALL PRIVILEGES ON ituser.* TO 'ituser'@'localhost' IDENTIFIED BY 'mypass'; exit; The GRANT allows ituser to do anything to his/her own database. If you need ituser to be able to connect remotely you'll have to update /e...
by cwc1911
Mon Jun 11, 2018 1:59 pm
Forum: General discussion
Topic: MySQL OUTFILE Errcode: 13 "Permission denied"
Replies: 3
Views: 7059

Re: MySQL OUTFILE Errcode: 13 "Permission denied"

So I was able to create my output file by logging into MySQL as the root user and using a different path. I created this directory /tmp/data and used chmod 777 to grant everyone permissions. I am not sure if this the best solution. I really want my database app user [ituser] to be able to connect to...
by cwc1911
Sun Jun 10, 2018 8:35 pm
Forum: General discussion
Topic: MySQL OUTFILE Errcode: 13 "Permission denied"
Replies: 3
Views: 7059

MySQL OUTFILE Errcode: 13 "Permission denied"

I am getting and error while trying to export data from a MySQL table to a file using the following command. SQL: select id, name from test_data into outfile '/home/pi/shared/test.csv' fields terminated by ',' enclosed by '"' lines terminated by '\n'; ERROR 1 (HY000): Can't create/write to file '/ho...

Go to advanced search