Why am I getting LOAD DATA INFILE Error Code 13 in MySQL?

LOAD DATA INFILE Error Code: 13 - Resolving File Access Issues

Encounters with the MySQL Error Code 13 while executing the LOAD DATA INFILE query can be frustrating. This error typically occurs when MySQL encounters an issue accessing the specified file.

One common cause of this error is improper file or folder permissions. To resolve this, ensure that the database user has the necessary file access privileges. Verify that the user has read and write permissions on the specified file and its parent directory.

To further troubleshoot this issue, consider the following steps, which have been known to resolve the Error Code 13 in specific scenarios:

Check AppArmor Configuration (Ubuntu Only):

If the MySQL server is running on a Ubuntu system, AppArmor, a security module, might be blocking MySQL from accessing files. To address this, edit the /etc/apparmor.d/usr.sbin.mysqld file. Add the line /tmp/** rwk to the file and reload AppArmor using the command:

<code class="sh">sudo /etc/init.d/apparmor reload</code>

Verify File Ownership:

Ensure that the file you are attempting to load is owned by the MySQL user. To do this, execute the following command:

<code class="sh">chown mysql:mysql /httpdocs/.../.../testFile.csv</code>

Disable SELinux:

If SELinux is enabled on your system, it might be interfering with file access. Temporarily disable SELinux to check if that resolves the issue:

<code class="sh">setenforce 0</code>

By implementing these steps, you can troubleshoot and resolve the LOAD DATA INFILE Error Code 13, ensuring that MySQL can successfully access and load files into your tables.

The above is the detailed content of Why am I getting LOAD DATA INFILE Error Code 13 in MySQL?. For more information, please follow other related articles on the PHP Chinese website!