ERROR 1 (HY000): Can't create/write to file '/home/anscmysql/ansc/list2.csv' (Errcode: 13)

Question

在MYSQL下 我希望导出一张表的时候，提示无法创建mysql> select * from nlist into outfile '/home/anscmysql/ansc/list.csv' FIELDS TERMINATED BY ',' ESCAPED BY '\\' LINES TERMINATED BY '\n';
ERROR 1 (HY000): Can't create/write to file '/home/anscmysql/ansc/list2.csv' (Errcode: 13)
已经有权限创建文件，之前我还正常导出

Answer 1

从Errcode: 13看可能是你没有权限在ansc下创建文件并写文件