在MySQL中创建/写入权限 [英] Create/Write Permissions in MySQL

问题描述

我的SELECT ... INTO OUTFILE语句遇到一些权限问题.

I am experiencing some permission problems with my SELECT ... INTO OUTFILE statement.

当我登录数据库并执行简单的导出命令时，例如:

When I log into my database and do a simple export command, eg:

mysql> select * from XYZ into outfile '/home/mropa/Photos/Desktop/TEST.txt';

我得到答复:

ERROR 1 (HY000): 
Can't create/write to file '/home/mropa/Photos/Desktop/TEST.txt' 
(Errcode: 13)

但是，当我简单地写:

mysql> select * from XYZ into outfile 'TEST.txt';
Query OK, 8287 rows affected (0.73 sec)

文件被写入目录/var/lib/mysql/XYZ. 我查看了文件/etc/apparmor.d/usr.sbin.mysqld，其中mysql似乎定义了读写权限，但是我真的不知道如何修改它.

The file is written into the directory /var/lib/mysql/XYZ. I looked into the file /etc/apparmor.d/usr.sbin.mysqld where mysql seems to define the reading and writting permissions but I don't really know how to modify it.

如何授予自己将mysql表导出到我喜欢的任何目录的权限?

How can I give myself permission to export a mysql table into any directory I like?

推荐答案

问题是目录权限. mysqld不以current_user身份运行.将mysqld用户添加到对目标目录具有写权限的组(方便但不安全)，或者记住在写入输出文件之前和之后更改目标目录的权限.

The issue is directory permissions. mysqld does not run as current_user. Add the mysqld user to the group that has write permissions on your target directories (convenient, but not as secure) or remember to change your target directory permissions before and after you write the outfile.

这篇关于在MySQL中创建/写入权限的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！