DataGrip 问题加载数据本地 Infile

我在使用LOAD DATA LOCAL INFILEDatagrip 中的语句时遇到问题。假设我有source_data.csv这样的：

rating,statement
-2,"I'm hungry!"
5,"I'm satisfied."
1,"Ok, but could be better."

在 DataGrip 中运行以下代码块后：

# loading_sample_table.sql

USE sample_db;

DROP TABLE IF EXISTS sample_table;
CREATE TABLE sample_table (rating int, statement varchar(50), id serial);

LOAD DATA
    LOCAL INFILE 'absolute/path/to/my/source_data.csv'
    INTO TABLE sample_table
    FIELDS TERMINATED BY ','
    OPTIONALLY ENCLOSED BY  '\''
    LINES TERMINATED BY '\n'
    IGNORE 1 LINES
    (rating, statement);

我收到以下错误：

[42000][1148] The used command is not allowed with this MySQL version

SHOW VARIABLES LIKE "%version%";在 MySQL shell 或 DataGrip 中运行会产生

+--------------------------+-------------------------------+
| Variable_name            | Value                         |
+--------------------------+-------------------------------+
| immediate_server_version | 999999                        |
| innodb_version           | 8.0.18                        |
| original_server_version  | 999999                        |
| protocol_version         | 10                            |
| slave_type_conversions   |                               |
| tls_version              | TLSv1,TLSv1.1,TLSv1.2,TLSv1.3 |
| version                  | 8.0.18                        |
| version_comment          | MySQL Community Server - GPL  |
| version_compile_machine  | x86_64                        |
| version_compile_os       | macos10.14                    |
| version_compile_zlib     | 1.2.11                        |
+--------------------------+-------------------------------+

然后，如果我尝试上面相同的命令但只是LOCAL从代码块中删除，我会收到以下错误：

[HY000][13] Can't get stat of 'absolute/path/to/my/source_data.csv' (OS errno 13 - Permission denied)

另外，我检查SHOW GLOBAL VARIABLES LIKE 'local_infile';并可以看到：

+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| local_infile  | ON    |
+---------------+-------+

但是，如果从我的终端运行：

mysql --local-infile=1 -uroot -p < 'absolute/path/to/my/loading_sample_table.sql'

输入我的root密码后，文件运行成功。理想情况下，我想在 DataGrip 中做所有事情。不确定如何调试此问题。