ubuntu 12.04 mysql 错误 Errcode 13

转载自：http://www.cnblogs.com/zhangjun516/archive/2013/01/21/2869792.html

mysql> select * into outfile '/home/angelmylove/mysql/student.txt' fields terminated by ',' optionally enclosed by '"' lines terminated by '\n' from student limit 100;
ERROR 1 (HY000): Can't create/write to file '/home/angelmylove/mysql/student.txt' (Errcode: 13)

 

1,chmod -R 777 文件位置

 

2，

# sudo aa-status 
5 profiles are loaded. 
5 profiles are in enforce mode. 

   /usr/lib/connman/scripts/dhclient-script 

   /sbin/dhclient3 

   /usr/sbin/tcpdump 

   /usr/lib/NetworkManager/nm-dhcp-client.action 
   /usr/sbin/mysqld  要是有这个表示mysql被限制了执行下面绿色的命令
0 profiles are in complain mode. 
1 processes have profiles defined. 
1 processes are in enforce mode : 

   /usr/sbin/mysqld (1089) 
0 processes are in complain mode. 

If mysqld is included in enforce mode, then it is the one probably denying the write. Entries would also be written in /var/log/messages when AppArmor blocks the writes/accesses. What you can do is edit /etc/apparmor.d/usr.sbin.mysqld and add /data/ and /data/* near the bottom like so:

...
/usr/sbin/mysqld {
    ...
    /var/log/mysql/ r,
    /var/log/mysql/* rw,
    /var/run/mysqld/mysqld.pid w,
    /var/run/mysqld/mysqld.sock w,
    /文件路径/ r,  添加要生成文件的路径
    /文件路径/* rw,添加要生成文件的路径

//重新加载

 

# sudo /etc/init.d/apparmor reload 

 

mysql> select * into outfile '/home/angelmylove/mysql/student.txt' fields terminated by ',' optionally enclosed by '"' lines terminated by '\n' from student limit 100;
Query OK, 0 rows affected (0.00 sec)