mysql禁止加载本地数据_禁用安全私有以加载MySQL上的数据

我无法重现这个问题.

mysql> SELECT VERSION();

+-----------+

| VERSION() |

+-----------+

| 5.7.13 |

+-----------+

1 row in set (0,00 sec)

mysql> SELECT @@GLOBAL.secure_file_priv;

+---------------------------+

| @@GLOBAL.secure_file_priv |

+---------------------------+

| NULL |

+---------------------------+

1 row in set (0,00 sec)

-- USE ...

mysql> LOAD DATA INFILE '/var/lib/mysql-files/myfile.csv'

-> INTO TABLE `test_files`

-> COLUMNS TERMINATED BY ',' ENCLOSED BY '\"'

-> LINES TERMINATED BY '\n';

ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv

option so it cannot execute this statement

更改文件：/etc/mysql/my.cnf

[mysqld]

.

.

.

secure_file_priv=/var/lib/mysql-files/

.

.

.

重启MySQL.

mysql> SELECT @@GLOBAL.secure_file_priv;

+---------------------------+

| @@GLOBAL.secure_file_priv |

+---------------------------+

| /var/lib/mysql-files/ |

+---------------------------+

1 row in set (0,00 sec)

mysql> LOAD DATA INFILE '/var/lib/mysql-files/myfile.csv'

-> INTO TABLE `test_files`

-> COLUMNS TERMINATED BY ',' ENCLOSED BY '\"'

-> LINES TERMINATED BY '\n';

Query OK, 3 rows affected (0,00 sec)

Records: 3 Deleted: 0 Skipped: 0 Warnings: 0