MySQL导入数据load data报错 '/var/lib/mysql-files/realVal.csv' not found (Errcode: 13 - Permission deni

Linux 系统下导入数据命令：

load data infile '/var/lib/mysql-files/realVal.csv' into table realVal fields terminated by ',' optionally enclosed by '"' escaped by '"' lines terminated by '\r\n';

报错：

ERROR 29 (HY000): File '/var/lib/mysql-files/realVal.csv' not found (Errcode: 13 - Permission denied)

解决方法：

加“local”，即 load data local infile '~/ils/src/ils_DAP/realVal.csv' into table realVal fields terminated by ',' optionally enclosed by '"' escaped by '"' lines terminated by '\r\n';

此时文件可以在本地中随意位置。

浏览时，看见有些解决方法是修改权限文件内容等方法。