MySQL error when doing INTO OUTFILE

When trying to run INTO OUTFILE query in MySQL (Ver 8.0.17) i get

SQL Error [1] [HY000]: Can't create/write to file '/home/....' (OS errno 13 - Permission denied)

When I had same problem on Ubuntu it was related to AppArmor and was able to fix it fallowing:
https://stackoverflow.com/questions/2783313/how-can-i-get-around-mysql-errcode-13-with-select-into-outfile
In Manjaro problem is that when i run sudo aa-status don't have mysqld profile and don't know how to add / crate it. More to it /etc/apparmor.d/usr.sbin.mysqld or /etc/apparmor.d/local/usr.sbin.mysqld does not exist.

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.

Forum kindly sponsored by