MySQL on MACOS Sierra secure-file-priv setting
on mac os x startup parameters of mysql You can change by edit .plist file

location:

/Library/LaunchDaemons
com.oracle.oss.mysql.mysqld.plist


Use Xcode or for example BBEdit, and add line in section ProgramArguments

&lt;?xml version="1.0" encoding="UTF-8"?&gt;
&lt;!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd"&gt;
&lt;plist version="1.0"&gt;
&lt;dict&gt;
    &lt;key&gt;Disabled&lt;/key&gt;
    &lt;false/&gt;
    &lt;key&gt;ExitTimeOut&lt;/key&gt;
    &lt;integer&gt;600&lt;/integer&gt;
    &lt;key&gt;GroupName&lt;/key&gt;
    &lt;string&gt;_mysql&lt;/string&gt;
    &lt;key&gt;KeepAlive&lt;/key&gt;
    &lt;false/&gt;
    &lt;key&gt;Label&lt;/key&gt;
    &lt;string&gt;com.oracle.oss.mysql.mysqld&lt;/string&gt;
    &lt;key&gt;LaunchOnlyOnce&lt;/key&gt;
    &lt;false/&gt;
    &lt;key&gt;ProcessType&lt;/key&gt;
    &lt;string&gt;Interactive&lt;/string&gt;
    &lt;key&gt;Program&lt;/key&gt;
    &lt;string&gt;/usr/local/mysql/bin/mysqld&lt;/string&gt;
    &lt;key&gt;ProgramArguments&lt;/key&gt;
    &lt;array&gt;
        &lt;string&gt;/usr/local/mysql/bin/mysqld&lt;/string&gt;
        &lt;string&gt;--user=_mysql&lt;/string&gt;
        &lt;string&gt;--basedir=/usr/local/mysql&lt;/string&gt;
        &lt;string&gt;--datadir=/usr/local/mysql/data&lt;/string&gt;
        &lt;string&gt;--plugin-dir=/usr/local/mysql/lib/plugin&lt;/string&gt;
        &lt;string&gt;--log-error=/usr/local/mysql/data/mysqld.local.err&lt;/string&gt;
        &lt;string&gt;--pid-file=/usr/local/mysql/data/mysqld.local.pid&lt;/string&gt;
        &lt;string&gt;--secure-file-priv=/mysql_exp&lt;/string&gt;
    &lt;/array&gt;
    &lt;key&gt;RunAtLoad&lt;/key&gt;
    &lt;false/&gt;
    &lt;key&gt;SessionCreate&lt;/key&gt;
    &lt;true/&gt;
    &lt;key&gt;UserName&lt;/key&gt;
    &lt;string&gt;_mysql&lt;/string&gt;
    &lt;key&gt;WorkingDirectory&lt;/key&gt;
    &lt;string&gt;/usr/local/mysql&lt;/string&gt;
&lt;/dict&gt;
&lt;/plist&gt;


restart MySQL and check:

mysql&gt; show variables like 'secure%';
+------------------+-------------+
| Variable_name    | Value       |
+------------------+-------------+
| secure_auth      | ON          |
| secure_file_priv | /mysql_exp/ |
+------------------+-------------+
2 rows in set (0.00 sec)


Add:

You can achieve same result if will create my.cnf file straight in /etc/

sudo nano /etc/my.cnf


You can copy example file from 

/usr/local/mysql/support-files/


just notes about comments - "copy/past" it's not a way, even on Your Mac You really do not need file import/export at all
just use normal tools like:


MySQL Workbench
Navicat for MySQL
JetBrain IDE (most of them have database module)
DBVisualizer


any of them can help You:


export result of query into different format - csv, delimited file, json, xls
Import popular format of files direct into table, with mapping columns to datatypes


manual file level import/export could be useful in production environment where You need automate processes, but also for now it is more backup way, primary and proper - ETL scripts and tools.