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

mysql> select concat("kill ",id,";") from information_schema.PROCESSLIST where command="Query" or command="Execute" into outfile "/tmp/kill.sql";
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
mysql>

参数文件增加secure-file-priv 需要重启，因此还是提前设置好吧
secure-file-priv=/tmp

mysql> system ls /tmp/
kill.sql
ssh-Ga9ZUIvl48
ssh-gnmUMC4ynQ
systemd-private-78188cfd18fd4deba9f1966cfae71984-colord.service-UN9M7I
systemd-private-78188cfd18fd4deba9f1966cfae71984-cups.service-kMgzdC
systemd-private-78188cfd18fd4deba9f1966cfae71984-rtkit-daemon.service-AKFpKQ
yum_save_tx.2019-07-10.15-28.Bvak4E.yumtx