Скачать или смотреть ERROR 2068 (HY000): LOAD DATA LOCAL INFILE file request rejected due to restrictions on access

The error message "ERROR 2068 (HY000): LOAD DATA LOCAL INFILE file request rejected due to restrictions on access" indicates that the MySQL server rejected the LOAD DATA LOCAL INFILE command due to restrictions on accessing local files.

The LOAD DATA LOCAL INFILE command is used to load data from a local file into a MySQL table. However, for security reasons, MySQL might restrict this functionality to prevent potential vulnerabilities that could arise from loading data from arbitrary files on the client's local machine.

To resolve this issue, you can consider the following steps:

Check MySQL Configuration:
Verify the MySQL server configuration to ensure that the local-infile option is enabled. This option controls whether the server allows the use of LOAD DATA LOCAL INFILE command. If it's not enabled, you need to enable it and then restart the MySQL server.

Add the following line in your MySQL configuration file (usually my.cnf or my.ini), under the [mysqld] section:

local-infile=1
After making this change, restart the MySQL server for the configuration to take effect.

Command Syntax:
Double-check the syntax of your LOAD DATA LOCAL INFILE command. Make sure you're using the correct file path and that the file is accessible from the client machine where you're executing the command.

File Permissions:
Ensure that the local file you're trying to load has appropriate read permissions for the MySQL process or user. The MySQL server process needs to have sufficient permissions to access the file.

Appropriate File Locations:
The file path you provide in the LOAD DATA LOCAL INFILE command should be relative to the client machine, not the server. Ensure that you're specifying the correct file path.

Avoid Using LOCAL:
If the LOAD DATA LOCAL INFILE command continues to give you trouble, you might consider copying the file to the MySQL server machine and then using the LOAD DATA INFILE command without the LOCAL keyword. This way, the file is located on the server and doesn't require the same local file access restrictions.