How can I get around MySQL Errcode 13 with SELECT INTO OUTFILE?

by

Which particular version of Ubuntu is this and is this Ubuntu Server Edition?

Recent Ubuntu Server Editions (such as 10.04) ship with AppArmor and MySQL’s profile might be in enforcing mode by default. You can check this by executing sudo aa-status like so:

# 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
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,  
    **/data/ r,  
    /data/* rw,**  
}

And then make AppArmor reload the profiles.

# sudo /etc/init.d/apparmor reload

WARNING: the change above will allow MySQL to read and write to the /data directory. We hope you’ve already considered the security implications of this.

More Related Contents:

  1. MySQL export into outfile : CSV escaping chars
  2. MySQL – SELECT * INTO OUTFILE LOCAL ?
  3. SQL select only rows with max value on a column [duplicate]
  4. How to create a MySQL hierarchical recursive query?
  5. SELECTING with multiple WHERE conditions on same column
  6. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  7. How to find gaps in sequential numbering in mysql?
  8. MySQL: Invalid use of group function
  9. Combining UNION and LIMIT operations in MySQL query
  10. MySQL comparison with null value
  11. MySQL JOIN the most recent row only?
  12. OUTPUT Clause in MySQL
  13. Search all columns of a table using a single where condition with single keyword in mysql
  14. What does SQL clause “GROUP BY 1” mean?
  15. Sorting by date & time in descending order?
  16. Case statement in MySQL
  17. MySQL, Concatenate two columns
  18. MySQL: Inner join vs Where [duplicate]
  19. Syntax error when using except in a query
  20. Selecting from two tables with inner join and limit [duplicate]
  21. Why the order of evaluation for expressions involving user variables is undefined?
  22. sql like operator on integer
  23. How to select data where a field has a min value in MySQL?
  24. How to SELECT by MAX(date)?
  25. The best way to remove value from SET field?
  26. get a recursive parent list
  27. MySQL OPTIMIZE all tables?
  28. Strip last two characters of a column in MySQL
  29. What happens when I exhaust a bigint generated key? How to handle it?
  30. is there a length limit to group_concat or another reason why it would not work on a text field

Leave a Comment