无法将数据导入MySQL表

在MySQL版本8.0.27-0上,我们在将条目导入表时遇到问题。我已经能够用一个简单的例子重现这个问题。请注意,所有权限都已授予用户。

CREATE TABLE people
(
  id  INT UNSIGNED  NOT NULL AUTO_INCREMENT,
  name  CHAR(40) NOT  NULL DEFAULT '',
  age  INT NOT NULL  DEFAULT 0,
  PRIMARY KEY (id)
);

然后我创建了文件/tmp/people。txt,包含以下条目:

1   William 25
2   Mary    37

文件的权限没有问题,因为 system '/tmp/people.txt' 给出以下输出:

mysql> system cat '/tmp/people.txt'
1   William 25
2   Mary    37

然而,当我尝试

LOAD DATA INFILE '/tmp/people.txt' INTO TABLE people;

我得到以下错误:

mysql> LOAD DATA INFILE '/tmp/people.txt' INTO TABLE people;
ERROR 29 (HY000): File '/tmp/people.txt' not found (OS errno 13 - Permission denied)

档案 /tmp/people.txt 已获得777许可,所以我不确定发生了什么。

当我尝试 mysqlimport soverflow people.txt 从…起 /tmp 目录,我得到以下错误:

mysqlimport: Error: 13, Can't get stat of '/var/lib/mysql/soverflow/people.txt' (OS errno 2 - No such file or directory), when using table: people