ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot exec

当尝试用select ... into output导出表的时候提示：

ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement

网上查了一下应该是这个参数secure-file-priv为空的原因，需要在/etc/my.cnf中设置一下目标路径并重启mysql服务。

mysql> show variables like '%secure%';
+--------------------------+-------+
| Variable_name            | Value |
+--------------------------+-------+
| require_secure_transport | OFF   |
| secure_auth              | ON    |
| secure_file_priv         | NULL  |
+--------------------------+-------+
3 rows in set (0.01 sec)

[root@qht131 ~]# mysql --user=root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.21 MySQL Community Server (GPL)

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use l5m
Database changed
mysql> select * from t1 into outfile '/u01/backup/t1.sql';
Query OK, 4 rows affected (0.07 sec)