Consistently Encountering Errors with LOAD DATA LOCAL INFILE

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: LOAD DATA LOCAL INFILE 一直报错

| username: 路在何chu

[TiDB Usage Environment] Production Environment
4013
[Reproduction Path] What operations were performed when the issue occurred
Importing data
[Encountered Issue: Phenomenon and Impact]
LOAD DATA LOCAL INFILE ‘nova_digital_record22.txt’ INTO TABLE t3;
ERROR 2068 (HY000): LOAD DATA LOCAL INFILE file request rejected due to restrictions on access.
[Resource Configuration] Go to TiDB Dashboard - Cluster Info - Hosts and take a screenshot of this page
[Attachment: Screenshot/Log/Monitoring]
mysql> LOAD DATA LOCAL INFILE ‘nova_digital_record22.txt’ INTO TABLE t3;
ERROR 2068 (HY000): LOAD DATA LOCAL INFILE file request rejected due to restrictions on access.
mysql> system ls -l ;
total 86076
-rw-r–r-- 1 tidb tidb 88133594 Jan 22 09:30 nova_digital_record22.txt

2
| username: 路在何chu | Original post link

The file has permissions.

3
| username: 路在何chu | Original post link

Ignore it, solved it by adding --local-infile during login.

4
| username: Kongdom | Original post link

:+1: :+1: :+1: Self Q&A
But there’s a similar one with a different solution

5
| username: ShawnYan | Original post link

I encountered a similar issue in this article

6
| username: dba远航 | Original post link

Solved.

7
| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.