blocks|key|970443|text|它按预期工作了。您的MySQL服务器已使用-安全-档案-priv选项启动，该选项限制可以使用LOAD+DATA+INFILE加载文件的目录。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|970444|使用SHOW+VARIABLES+LIKE+"secure_file_priv";查看已配置的目录。|970445|你有两个选择：|970446|将文件移动到secure-file-priv指定的目录。|ordered-list-item|970447|禁用secure-file-priv。这必须从启动中删除，并且不能动态修改。为此，请检查MySQL启动参数(取决于平台)和my.ini。|970448|entityMap|0|LINK|mutability|MUTABLE|url|https://dev.mysql.com/doc/refman/5.0/en/server-options.html#option_mysqld_secure-file-priv^0|1A|G|L|B|0|0|2|13|0|0|6|G|0|2|G|0^^$0|@$1|2|3|4|5|6|7|W|8|@$9|X|A|Y|B|C]]|D|@$9|Z|A|10|1|11]]|E|$]]|$1|F|3|G|5|6|7|12|8|@$9|13|A|14|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|15|8|@]|D|@]|E|$]]|$1|J|3|K|5|L|7|16|8|@$9|17|A|18|B|C]]|D|@]|E|$]]|$1|M|3|N|5|L|7|19|8|@$9|1A|A|1B|B|C]]|D|@]|E|$]]|$1|O|3|-4|5|6|7|1C|8|@]|D|@]|E|$]]]|P|$Q|$5|R|S|T|E|$U|V]]]]

It's working as intended. Your MySQL server has been started with <a href="https://dev.mysql.com/doc/refman/5.0/en/server-options.html#option_mysqld_secure-file-priv" rel="noreferrer">--secure-file-priv</a> option which limits from which directories you can load files using <code>LOAD DATA INFILE</code>.
Use <code>SHOW VARIABLES LIKE &quot;secure_file_priv&quot;;</code> to see the directory that has been configured.
You have two options:
<ol>
<li>Move your file to the directory specified by <code>secure-file-priv</code>.</li>
<li>Disable <code>secure-file-priv</code>. This must be removed from startup and cannot be modified dynamically. To do this check your MySQL start up parameters (depending on platform) and my.ini.</li>
</ol>

blocks|key|355684|text|我使用命令中的LOCAL选项解决了这个问题：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|355685|LOAD+DATA+LOCAL+INFILE+"text.txt"+INTO+TABLE+mytable;|code-block|syntax|javascript|355686|你可以找到更多的信息，这里。|355687|如果指定了本地文件，则由客户端主机上的客户端程序读取文件并发送到服务器。文件可以作为一个完整的路径名来指定它的确切位置。如果指定为相对路径名，则该名称将相对于启动客户端程序的目录进行解释。|blockquote|355688|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/doc/refman/5.7/en/load-data.html^0|7|5|0|0|B|2|0|0|0^^$0|@$1|2|3|4|5|6|7|X|8|@$9|Y|A|Z|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|10|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|11|8|@]|D|@$9|12|A|13|1|14]]|E|$]]|$1|M|3|N|5|O|7|15|8|@]|D|@]|E|$]]|$1|P|3|-4|5|6|7|16|8|@]|D|@]|E|$]]]|Q|$R|$5|S|T|U|E|$V|W]]]]

I solved it using the <code>LOCAL</code> option in the command:
<pre><code>LOAD DATA LOCAL INFILE &quot;text.txt&quot; INTO TABLE mytable;
</code></pre>
You can find more info <a href="http://dev.mysql.com/doc/refman/5.7/en/load-data.html" rel="noreferrer">here</a>.
<blockquote>
If LOCAL is specified, the file is read by the client program on the
client host and sent to the server. The file can be given as a full
path name to specify its exact location. If given as a relative path
name, the name is interpreted relative to the directory in which the
client program was started.
</blockquote>

blocks|key|355670|text|在Ubuntu+14和Mysql+5.5.53上，这个设置在默认情况下似乎是启用的。要禁用它，需要将secure-file-priv+=+""添加到mysqld配置组下的my.cnf文件中。例：-|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|355671|[mysqld]
secure-file-priv+=+""|code-block|syntax|javascript|355672|entityMap^0|1E|L|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

On Ubuntu 14 and Mysql 5.5.53 this setting seems to be enabled by default. To disable it you need to add <code>secure-file-priv = ""</code> to your my.cnf file under the mysqld config group. eg:-

<pre><code>[mysqld]
secure-file-priv = ""
</code></pre>

blocks|key|970778|text|@vhu我做了SHOW+VARIABLES+LIKE+"secure_file_priv";，它返回了C:\ProgramData\MySQL\MySQL+Server+8.0\Uploads\，所以当我插入它时，它仍然不起作用。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|970779|当我直接进入my.ini文件时，我发现路径的格式有点不同：|970780|C:/ProgramData/MySQL/MySQL+Server+8.0/Uploads|code-block|syntax|javascript|970781|然后当我用它运行的时候，它就起作用了。唯一的区别是斜杠的方向。|970782|entityMap^0|7|13|1F|1A|0|6|6|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@$9|R|A|S|B|C]|$9|T|A|U|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|V|8|@$9|W|A|X|B|C]]|D|@]|E|$]]|$1|H|3|I|5|J|7|Y|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|Z|8|@]|D|@]|E|$]]|$1|O|3|-4|5|6|7|10|8|@]|D|@]|E|$]]]|P|$]]

@vhu I did the <code>SHOW VARIABLES LIKE &quot;secure_file_priv&quot;;</code> and it returned <code>C:\ProgramData\MySQL\MySQL Server 8.0\Uploads\</code> so when I plugged that in, it still didn't work.
When I went to the <code>my.ini</code> file directly I discovered that the path is formatted a bit differently:
<pre><code>C:/ProgramData/MySQL/MySQL Server 8.0/Uploads
</code></pre>
Then when I ran it with that, it worked. The only difference was the direction of the slashes.

blocks|key|355619|text|我正在使用Debian上的MySQL5.7.11，对我来说，查看目录的命令是：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|355620|mysql>+SELECT+@@global.secure_file_priv;|code-block|syntax|javascript|355621|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I'm working on MySQL5.7.11 on Debian, the command that worked for me to see the directory is:

<pre><code>mysql&gt; SELECT @@global.secure_file_priv;
</code></pre>

blocks|key|355636|text|下面是我在Windows+7中禁用secure-file-priv的方法(vhu的回答中的选项2)：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|355637|通过进入MySQL服务器服务来停止services.msc服务。|ordered-list-item|355638|转到C:\ProgramData\MySQL\MySQL+Server+5.6+(在我的例子中，ProgramData是一个隐藏的文件夹)。|355639|在记事本中打开my.ini文件。|355640|搜索“安全文件-priv”。|355641|在行的开头加上“#”来注释这一行。对于MySQL+Server+5.7.16及更高版本，注释不起作用。您必须将它设置为一个空字符串，如这个-+secure-file-priv=""。|355642|保存文件。|355643|通过进入MySQL服务器来启动services.msc服务器服务。|355644|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/a/32737616/209139^0|H|G|11|6|0|0|H|C|0|2|11|1C|B|0|7|6|0|0|1Z|J|0|0|F|C|0^^$0|@$1|2|3|4|5|6|7|12|8|@$9|13|A|14|B|C]]|D|@$9|15|A|16|1|17]]|E|$]]|$1|F|3|G|5|H|7|18|8|@$9|19|A|1A|B|C]]|D|@]|E|$]]|$1|I|3|J|5|H|7|1B|8|@$9|1C|A|1D|B|C]|$9|1E|A|1F|B|C]]|D|@]|E|$]]|$1|K|3|L|5|H|7|1G|8|@$9|1H|A|1I|B|C]]|D|@]|E|$]]|$1|M|3|N|5|H|7|1J|8|@]|D|@]|E|$]]|$1|O|3|P|5|H|7|1K|8|@$9|1L|A|1M|B|C]]|D|@]|E|$]]|$1|Q|3|R|5|H|7|1N|8|@]|D|@]|E|$]]|$1|S|3|T|5|H|7|1O|8|@$9|1P|A|1Q|B|C]]|D|@]|E|$]]|$1|U|3|-4|5|6|7|1R|8|@]|D|@]|E|$]]]|V|$W|$5|X|Y|Z|E|$10|11]]]]

Here is what worked for me in Windows 7 to disable <code>secure-file-priv</code> (Option #2 from <a href="https://stackoverflow.com/a/32737616/209139">vhu's answer</a>):

<ol>
<li>Stop the MySQL server service by going into <code>services.msc</code>.</li>
<li>Go to <code>C:\ProgramData\MySQL\MySQL Server 5.6</code> (<code>ProgramData</code> was a hidden folder in my case).</li>
<li>Open the <code>my.ini</code> file in Notepad.</li>
<li>Search for 'secure-file-priv'.</li>
<li>Comment the line out by adding '#' at the start of the line. For MySQL Server 5.7.16 and above, commenting won't work. You have to set it to an empty string like this one - <code>secure-file-priv=""</code></li>
<li>Save the file.</li>
<li>Start the MySQL server service by going into <code>services.msc</code>.</li>
</ol>

blocks|key|355798|text|如果文件是机器的本地文件，则在命令中使用本地|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|355799|LOAD+DATA+LOCAL+INFILE+"text.txt"+INTO+table+mytable;|code-block|syntax|javascript|355800|entityMap^0|K|2|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

If the file is local to your machine use the LOCAL in your command

<pre><code>LOAD DATA LOCAL INFILE "text.txt" INTO table mytable;
</code></pre>

blocks|key|356063|text|在这篇文章发布的时候，这个线程已经被浏览了570+k次。老实说，MySQL什么时候成了我们过分保护的不合理的母亲？多么费时的一次安全尝试--这只会束缚我们！|type|unstyled|depth|inlineStyleRanges|entityRanges|data|356064|经过多次搜索和多次尝试，一切都失败了。我的解决方案：|356065|对我有用的是：|356066|通过在旧框上导入的.csv文件(如果在cmd行上做大的话)|ordered-list-item|offset|length|style|CODE|356067|生成一个.sql文件。|356068|下载.sql文件。|356069|通过.sql工作台导入MySQL文件。|356070|entityMap^0|0|0|0|9|4|0|4|4|0|2|4|0|2|4|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|W|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|X|8|@$I|Y|J|Z|K|L]]|9|@]|A|$]]|$1|M|3|N|5|H|7|10|8|@$I|11|J|12|K|L]]|9|@]|A|$]]|$1|O|3|P|5|H|7|13|8|@$I|14|J|15|K|L]]|9|@]|A|$]]|$1|Q|3|R|5|H|7|16|8|@$I|17|J|18|K|L]]|9|@]|A|$]]|$1|S|3|-4|5|6|7|19|8|@]|9|@]|A|$]]]|T|$]]

This thread has been viewed 570k times at the time of this post. Honestly when did MySQL become our over protective unreasonable mom? What a time consuming attempt at security - which really only serves to shackle us!
After many searches and many attempts everything failed.
My solution:
What worked for me was:
<ol>
<li>Import the <code>.csv</code> file via PhpMyAdmin import on older box (if large do at cmd line)</li>
<li>Generate a <code>.sql</code> file.</li>
<li>Download <code>.sql</code> file.</li>
<li>Import <code>.sql</code> file via MySQL Workbench.</li>
</ol>

blocks|key|1522006|text|对我起作用的是：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1522007|将文件放入secure-file-priv中指定的文件夹中。
要找到这种类型：
mysql>显示诸如“secure_file_priv”这样的变量；|ordered-list-item|offset|length|style|CODE|1522008|看看你有没有local_infile+=+1。
这样打字：
mysql>显示诸如“local_infile”这样的变量；
如果你得到：
%2B
然后将其设置为一次输入：
mysql>集全局local_infile+=+1；|1522009|指定文件的完整路径。就我而言：
mysql>将“C:/ProgramData/MySQL/MySQLServer8.0/Uploads/file.txt”加载到表测试中；|1522010|entityMap^0|0|5|G|0|6|G|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@$E|Q|F|R|G|H]]|9|@]|A|$]]|$1|I|3|J|5|D|7|S|8|@$E|T|F|U|G|H]]|9|@]|A|$]]|$1|K|3|L|5|D|7|V|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|N|$]]

The thing that worked for me:
<ol>
<li>Put your file inside of the folder specified in <code>secure-file-priv</code>.
To find that type:
<pre><code>mysql&gt; show variables like &quot;secure_file_priv&quot;; 
</code></pre>
</li>
<li>Check if you have <code>local_infile = 1</code>.
Do that typing:
<pre><code>mysql&gt; show variables like &quot;local_infile&quot;;
</code></pre>
If you get:
<pre><code>+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| local_infile | OFF |
+---------------+-------+
</code></pre>
Then set it to one typing:
<pre><code>mysql&gt; set global local_infile = 1;
</code></pre>
</li>
<li>Specify the full path for your file. In my case:
<pre><code>mysql&gt; load data infile &quot;C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/file.txt&quot; into table test;
</code></pre>
</li>
</ol>

blocks|key|355657|text|我在“安全文件-普利夫”上也有同样的问题。.ini文件中的注释不起作用，在‘secure’指定的目录中移动文件也不起作用。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|355658|最后，正如dbc所建议的那样，使“”等于空字符串有效。因此，如果有人在尝试了上面的答案后被困住了，希望这样做会有所帮助。|355659|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

I had the same problem with 'secure-file-priv'. Commenting in the .ini file didn't work and neither did moving file in directory specified by 'secure-file-priv'. 

Finally, as dbc suggested, making 'secure-file-priv' equal to an empty string worked. So if anyone is stuck after trying answers above, hopefully doing this will help.

blocks|key|356009|text|对于MySQL8.0版本，您可以这样做：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|356010|mysql.server+stop
mysql.server+start+--secure-file-priv=''|code-block|syntax|javascript|356011|在麦克高中塞拉对我来说很管用。|356012|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

For mysql 8.0 version you can do this:
<pre><code>mysql.server stop
mysql.server start --secure-file-priv=''
</code></pre>
It worked for me on Mac High Sierra.

blocks|key|355960|text|如果您正在Ubuntu上运行，您可能还需要配置Apparmor以允许MySQL写入您的文件夹，例如，下面是我的配置：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|355961|将这一行添加到文件/etc/parmor.d/usr.sbin.mysqld：|355962|/var/lib/mysql-files/*+rw|code-block|syntax|javascript|355963|然后将这2条配置行添加到/etc/mysql/my.cnf部分：|355964|[client]
loose-local-infile+=+1

[mysqld]
secure-file-priv+=+""|355965|这里是我的SQL：|355966|select+id+from+blahs+into+outfile+'/var/lib/mysql-files/blahs';|355967|对我起作用了。祝好运!|355968|entityMap^0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|W|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|X|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|Y|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|Z|8|@]|9|@]|A|$]]|$1|O|3|P|5|F|7|10|8|@]|9|@]|A|$G|H]]|$1|Q|3|R|5|6|7|11|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|T|$]]

If you're running on Ubuntu, you may also need to configure Apparmor to allow MySQL to write to your folder, e.g. here's my configuration:

Add this line to file /etc/apparmor.d/usr.sbin.mysqld :

<pre><code>/var/lib/mysql-files/* rw
</code></pre>

Then add these 2 config lines to /etc/mysql/my.cnf sections:

<pre><code>[client]
loose-local-infile = 1

[mysqld]
secure-file-priv = ""
</code></pre>

Here's my SQL:

<pre><code>select id from blahs into outfile '/var/lib/mysql-files/blahs';
</code></pre>

It worked for me. Good luck!

blocks|key|1522256|text|我创建了一个NodeJS导入脚本，如果您正在运行nodeJS，并且您的数据采用以下形式(双引号%2B逗号和\n新行)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1522257|INSERT+INTO+<your_table>+VALUEs(+**CSV+LINE+**)|code-block|syntax|javascript|1522258|这个配置为在http://localhost:5000/import上运行。|offset|length|1522259|我逐行创建查询字符串。|1522260|"city","city_ascii","lat","lng","country","iso2","iso3","id"
"Tokyo","Tokyo","35.6850","139.7514","Japan","JP","JPN","1392685764",
...|1522261|server.js|1522262|const+express+=+require('express'),
+++cors+=+require('cors'),
+++bodyParser+=+require('body-parser'),
+++cookieParser+=+require('cookie-parser'),
+++session+=+require('express-session'),
+++app+=+express(),
+++port+=+process.env.PORT+%7C%7C+5000,
+++pj+=+require('./config/config.json'),
+++path+=+require('path');

app.use(bodyParser.json());
app.use(cookieParser());
app.use(cors());


app.use(
+++bodyParser.urlencoded({
++++++extended:+false,
+++})
);

var+Import+=+require('./routes/ImportRoutes.js');

app.use('/import',+Import);
if+(process.env.NODE_ENV+===+'production')+{
+++//+set+static+folder
+++app.use(express.static('client/build'));

+++app.get('*',+(req,+res)+=>+{
++++++res.sendFile(path.resolve(__dirname,+'client',+'build',+'index.html'));
+++});
}

app.listen(port,+function+()+{
+++console.log('Server+is+running+on+port:+'+%2B+port);
});|1522263|ImportRoutes.js|1522264|const+express+=+require('express'),
+++cors+=+require('cors'),
+++fs+=+require('fs-extra'),
+++byline+=+require('byline'),
+++db+=+require('../database/db'),
+++importcsv+=+express.Router();

importcsv.use(cors());

importcsv.get('/csv',+(req,+res)+=>+{

+++function+processFile()+{
++++++return+new+Promise((resolve)+=>+{
+++++++++let+first+=+true;
+++++++++var+sql,+sqls;
+++++++++var+stream+=+byline(
++++++++++++fs.createReadStream('../PATH/TO/YOUR!!!csv',+{
+++++++++++++++encoding:+'utf8',
++++++++++++})
+++++++++);

+++++++++stream
++++++++++++.on('data',+function+(line,+err)+{
+++++++++++++++if+(line+!==+undefined)+{
++++++++++++++++++sql+=+'INSERT+INTO+<your_table>+VALUES+('+%2B+line.toString()+%2B+');';
++++++++++++++++++if+(first)+console.log(sql);
++++++++++++++++++first+=+false;
++++++++++++++++++db.sequelize.query(sql);
+++++++++++++++}
++++++++++++})
++++++++++++.on('finish',+()+=>+{
+++++++++++++++resolve(sqls);
++++++++++++});
++++++});
+++}

+++async+function+startStream()+{
++++++console.log('started+stream');
++++++const+sqls+=+await+processFile();
++++++res.end();
++++++console.log('ALL+DONE');
+++}

+++startStream();
});

module.exports+=+importcsv;|1522265|db.js是配置文件。|1522266|const+Sequelize+=+require('sequelize');
const+db+=+{};
const+sequelize+=+new+Sequelize(
+++config.global.db,
+++config.global.user,
+++config.global.password,
+++{
++++++host:+config.global.host,
++++++dialect:+'mysql',
++++++logging:+console.log,
++++++freezeTableName:+true,

++++++pool:+{
+++++++++max:+5,
+++++++++min:+0,
+++++++++acquire:+30000,
+++++++++idle:+10000,
++++++},
+++}
);

db.sequelize+=+sequelize;
db.Sequelize+=+Sequelize;

module.exports+=+db;|1522267|免责声明：--这不是一个完美的解决方案--我只是把它发布给那些在时间线下的开发人员，他们有大量的数据需要导入，并且遇到了这个荒谬的问题。我在这件事上浪费了很多时间，我希望能腾出另一段时间。|style|BOLD|1522268|entityMap|0|LINK|mutability|MUTABLE|url|http://localhost:5000/import^0|0|0|6|S|0|0|0|0|0|0|0|0|0|0|0|5|0^^$0|@$1|2|3|4|5|6|7|1C|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|1D|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|1E|8|@]|9|@$I|1F|J|1G|1|1H]]|A|$]]|$1|K|3|L|5|6|7|1I|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|1J|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|1K|8|@]|9|@]|A|$]]|$1|Q|3|R|5|D|7|1L|8|@]|9|@]|A|$E|F]]|$1|S|3|T|5|6|7|1M|8|@]|9|@]|A|$]]|$1|U|3|V|5|D|7|1N|8|@]|9|@]|A|$E|F]]|$1|W|3|X|5|6|7|1O|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|D|7|1P|8|@]|9|@]|A|$E|F]]|$1|10|3|11|5|6|7|1Q|8|@$I|1R|J|1S|12|13]]|9|@]|A|$]]|$1|14|3|-4|5|6|7|1T|8|@]|9|@]|A|$]]]|15|$16|$5|17|18|19|A|$1A|1B]]]]

I created a NodeJS import script if you are running nodeJS and you data is in the following form (double quote + comma and \n new line) 

<pre><code>INSERT INTO &lt;your_table&gt; VALUEs( **CSV LINE **)
</code></pre>

This one is configured to run on <a href="http://localhost:5000/import" rel="noreferrer">http://localhost:5000/import</a>.

I goes line by line and creates query string

<pre><code>"city","city_ascii","lat","lng","country","iso2","iso3","id"
"Tokyo","Tokyo","35.6850","139.7514","Japan","JP","JPN","1392685764",
...
</code></pre>

server.js

<pre class="lang-js prettyprint-override"><code>const express = require('express'),
 cors = require('cors'),
 bodyParser = require('body-parser'),
 cookieParser = require('cookie-parser'),
 session = require('express-session'),
 app = express(),
 port = process.env.PORT || 5000,
 pj = require('./config/config.json'),
 path = require('path');

app.use(bodyParser.json());
app.use(cookieParser());
app.use(cors());


app.use(
 bodyParser.urlencoded({
 extended: false,
 })
);

var Import = require('./routes/ImportRoutes.js');

app.use('/import', Import);
if (process.env.NODE_ENV === 'production') {
 // set static folder
 app.use(express.static('client/build'));

 app.get('*', (req, res) =&gt; {
 res.sendFile(path.resolve(__dirname, 'client', 'build', 'index.html'));
 });
}

app.listen(port, function () {
 console.log('Server is running on port: ' + port);
});
</code></pre>

ImportRoutes.js

<pre><code>const express = require('express'),
 cors = require('cors'),
 fs = require('fs-extra'),
 byline = require('byline'),
 db = require('../database/db'),
 importcsv = express.Router();

importcsv.use(cors());

importcsv.get('/csv', (req, res) =&gt; {

 function processFile() {
 return new Promise((resolve) =&gt; {
 let first = true;
 var sql, sqls;
 var stream = byline(
 fs.createReadStream('../PATH/TO/YOUR!!!csv', {
 encoding: 'utf8',
 })
 );

 stream
 .on('data', function (line, err) {
 if (line !== undefined) {
 sql = 'INSERT INTO &lt;your_table&gt; VALUES (' + line.toString() + ');';
 if (first) console.log(sql);
 first = false;
 db.sequelize.query(sql);
 }
 })
 .on('finish', () =&gt; {
 resolve(sqls);
 });
 });
 }

 async function startStream() {
 console.log('started stream');
 const sqls = await processFile();
 res.end();
 console.log('ALL DONE');
 }

 startStream();
});

module.exports = importcsv;
</code></pre>

db.js is the config file 

<pre><code>const Sequelize = require('sequelize');
const db = {};
const sequelize = new Sequelize(
 config.global.db,
 config.global.user,
 config.global.password,
 {
 host: config.global.host,
 dialect: 'mysql',
 logging: console.log,
 freezeTableName: true,

 pool: {
 max: 5,
 min: 0,
 acquire: 30000,
 idle: 10000,
 },
 }
);

db.sequelize = sequelize;
db.Sequelize = Sequelize;

module.exports = db;

</code></pre>

Disclaimer: This is not a perfect solution - I am only posting it for devs who are under a timeline and have lots of data to import and are encountering this ridiculous issue. I lost a lot of time on this and I hope to spare another dev the same lost time.

blocks|key|355698|text|我对此有各种各样的问题。我正在改变my.cnf和其他版本试图展示的各种疯狂的东西。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|355699|对我有用的是：|355700|我所犯的错误|355701|The+MySQL+server+is+running+with+the+--secure-file-priv+option+so+it+cannot+execute+this+statement|offset|length|style|CODE|355702|我能够通过打开/usr/local/mysql/support/mysql.server并更改以下行来修复它：|355703|$bindir/mysqld_safe+--datadir="$datadir"+--pid-file="$mysqld_pid_file_path"+--+$other_args+>/dev/null+&
++wait_for_pid+created+"$!"+"$mysqld_pid_file_path";+return_value=$?|code-block|syntax|javascript|355704|至|355705|$bindir/mysqld_safe+--datadir="$datadir"+--pid-file="$mysqld_pid_file_path"+--secure-file-priv=""+$other_args+>/dev/null+&
++wait_for_pid+created+"$!"+"$mysqld_pid_file_path";+return_value=$?|355706|entityMap^0|0|0|0|0|2Q|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Z|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|10|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|11|8|@$H|12|I|13|J|K]]|9|@]|A|$]]|$1|L|3|M|5|6|7|14|8|@]|9|@]|A|$]]|$1|N|3|O|5|P|7|15|8|@]|9|@]|A|$Q|R]]|$1|S|3|T|5|6|7|16|8|@]|9|@]|A|$]]|$1|U|3|V|5|P|7|17|8|@]|9|@]|A|$Q|R]]|$1|W|3|-4|5|6|7|18|8|@]|9|@]|A|$]]]|X|$]]

I had all sorts of problems with this. I was changing my.cnf and all sorts of crazy things that other versions of this problem tried to show.

What worked for me:

The error I was getting

<code>The MySQL server is running with the --secure-file-priv option so it cannot execute this statement</code>

I was able to fix it by opening /usr/local/mysql/support-files/mysql.server and changing the following line:

<pre><code>$bindir/mysqld_safe --datadir="$datadir" --pid-file="$mysqld_pid_file_path" -- $other_args &gt;/dev/null &amp;
 wait_for_pid created "$!" "$mysqld_pid_file_path"; return_value=$?
</code></pre>

to

<pre><code>$bindir/mysqld_safe --datadir="$datadir" --pid-file="$mysqld_pid_file_path" --secure-file-priv="" $other_args &gt;/dev/null &amp;
 wait_for_pid created "$!" "$mysqld_pid_file_path"; return_value=$?
</code></pre>

blocks|key|1522132|text|在macOS+Catalina，我按照以下步骤设置secure_file_priv|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1522133|1.停止MySQL服务|BOLD|1522134|+sudo+/usr/local/mysql/support-files/mysql.server+stop|code-block|syntax|javascript|1522135|2.2.Restart+MYSQL赋值--安全_file_priv变量|1522136|sudo+/usr/local/mysql/support-files/mysql.server+start+--secure-file-priv=YOUR_FILE_DIRECTORY|1522137|注意:为我添加空值修复了问题，MYSQL将将数据导出到/usr/local/mysql/data/YOUR_DB_TABLE/EXPORT_FILE目录|1522138|sudo+/usr/local/mysql/support-files/mysql.server+start+--secure-file-priv=|1522139|谢谢|1522140|entityMap^0|P|G|0|0|B|0|0|0|Z|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Z|8|@$9|10|A|11|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|12|8|@$9|13|A|14|B|H]]|D|@]|E|$]]|$1|I|3|J|5|K|7|15|8|@]|D|@]|E|$L|M]]|$1|N|3|O|5|6|7|16|8|@$9|17|A|18|B|H]]|D|@]|E|$]]|$1|P|3|Q|5|K|7|19|8|@]|D|@]|E|$L|M]]|$1|R|3|S|5|6|7|1A|8|@]|D|@]|E|$]]|$1|T|3|U|5|K|7|1B|8|@]|D|@]|E|$L|M]]|$1|V|3|W|5|6|7|1C|8|@]|D|@]|E|$]]|$1|X|3|-4|5|6|7|1D|8|@]|D|@]|E|$]]]|Y|$]]

At macOS Catalina, I followed this steps to set <code>secure_file_priv</code>

1.Stop MySQL service

<pre><code> sudo /usr/local/mysql/support-files/mysql.server stop
</code></pre>

2.Restart MYSQL assigning --secure_file_priv system variables 

<pre><code>sudo /usr/local/mysql/support-files/mysql.server start --secure-file-priv=YOUR_FILE_DIRECTORY
</code></pre>

Note: Adding empty value fix the issue for me, and MYSQL will export data to directory /usr/local/mysql/data/YOUR_DB_TABLE/EXPORT_FILE 

<pre><code>sudo /usr/local/mysql/support-files/mysql.server start --secure-file-priv=
</code></pre>

Thanks

blocks|key|970993|text|这对我起了作用(另外的问题是无法在语句加载日期INFILE中使用本地当前的MySQL版本.)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|970994|sudo+/usr/local/mysql/support-files/mysql.server+start+--secure-file-priv=''+--local-infile|code-block|syntax|javascript|970995|以上内容适用于我机器上的给定路径；您可能需要调整路径。|970996|然后使用：|970997|mysql+-u+root+-p|970998|重要的一点是，您应该在MySQL数据文件夹中使用CSV。在我的机器中，它位于:+/usr/local/mysql-8.0.18-macos10.14-x86_64/data|970999|如果需要，可以更改文件夹权限，以便在数据文件夹中删除CSV。|971000|设置：|971001|macOS+Catalina版本10.15.5|971002|MySQL版本8.0.18|971003|entityMap^0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|Z|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|10|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|11|8|@]|9|@]|A|$]]|$1|K|3|L|5|D|7|12|8|@]|9|@]|A|$E|F]]|$1|M|3|N|5|6|7|13|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|14|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|15|8|@]|9|@]|A|$]]|$1|S|3|T|5|6|7|16|8|@]|9|@]|A|$]]|$1|U|3|V|5|6|7|17|8|@]|9|@]|A|$]]|$1|W|3|-4|5|6|7|18|8|@]|9|@]|A|$]]]|X|$]]

This worked for me (had the additional problem of not being able to use LOCAL with my current MySQL version in the statement LOAD DATE INFILE ... )
<pre><code>sudo /usr/local/mysql/support-files/mysql.server start --secure-file-priv='' --local-infile
</code></pre>
The above works for that given path on my machine; you may have to adjust your path.
Then use:
<pre><code>mysql -u root -p
</code></pre>
One important point is that you should have the CSV in the MySQL data folder. In my machine it is located at: /usr/local/mysql-8.0.18-macos10.14-x86_64/data
You can change the folder permission if needed to drop a CSV in the data folder.
Setup: 
macOS Catalina version 10.15.5 
MySQL version 8.0.18

blocks|key|970761|text|MySQL使用此系统变量来控制可以导入文件的位置。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|970762|mysql>+SHOW+VARIABLES+LIKE+"secure_file_priv";
%2B------------------%2B-------%2B
%7C+Variable_name++++%7C+Value+%7C
%2B------------------%2B-------%2B
%7C+secure_file_priv+%7C+NULL++%7C
%2B------------------%2B-------%2B|code-block|syntax|javascript|970763|因此，问题在于如何更改系统变量(如secure_file_priv+)。|offset|length|style|CODE|970764|关机mysqld|ordered-list-item|970765|sudo+mysqld_safe+--secure_file_priv=""|970766|现在你可能会看到这样的情况：|970767|mysql>+SHOW+VARIABLES+LIKE+"secure_file_priv";
%2B------------------%2B-------%2B
%7C+Variable_name++++%7C+Value+%7C
%2B------------------%2B-------%2B
%7C+secure_file_priv+%7C+++++++%7C
%2B------------------%2B-------%2B|970768|entityMap^0|0|0|H|G|0|2|6|0|0|12|0|0|0^^$0|@$1|2|3|4|5|6|7|X|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|Y|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Z|8|@$I|10|J|11|K|L]]|9|@]|A|$]]|$1|M|3|N|5|O|7|12|8|@$I|13|J|14|K|L]]|9|@]|A|$]]|$1|P|3|Q|5|O|7|15|8|@$I|16|J|17|K|L]]|9|@]|A|$]]|$1|R|3|S|5|6|7|18|8|@]|9|@]|A|$]]|$1|T|3|U|5|D|7|19|8|@]|9|@]|A|$E|F]]|$1|V|3|-4|5|6|7|1A|8|@]|9|@]|A|$]]]|W|$]]

MySQL use this system variable to control where you can import you files

<pre><code>mysql&gt; SHOW VARIABLES LIKE "secure_file_priv";
+------------------+-------+
| Variable_name | Value |
+------------------+-------+
| secure_file_priv | NULL |
+------------------+-------+
</code></pre>

So problem is how to change system variables such as <code>secure_file_priv</code>.

<ol>
<li>shutdown <code>mysqld</code></li>
<li><code>sudo mysqld_safe --secure_file_priv=""</code></li>
</ol>

now you may see like this:

<pre><code>mysql&gt; SHOW VARIABLES LIKE "secure_file_priv";
+------------------+-------+
| Variable_name | Value |
+------------------+-------+
| secure_file_priv | |
+------------------+-------+
</code></pre>

blocks|key|971027|text|在Linux中，必须在|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|971028|/etc/mysql/my.cnf|code-block|syntax|javascript|971029|然后像这样修改26+line+number参数：|CODE|971030|secure-file-priv=+<your+data+path+directory+like+/home/user/data>|971031|然后重新启动MySQL，然后再试一次。|971032|在docker中，您必须在容器中挂载带有my.cnf文件的my.cnf文件，并使用下面的命令手动编写或添加：|971033|volumes:
++-+./persistent:/var/lib/mysql
++-+./conf/my.cnf:/etc/mysql/my.cnf|971034|接下来更改/conf/my.cnf在您的主机和配置安全文件-+param中，就像上面的方法一样，此外，您还必须在mysql容器中挂载数据并为secure设置路径并重新启动服务，最后，您可以加载数据。|971035|您可以使用以下命令检查您的配置：|971036|SHOW+VARIABLES+LIKE+"secure_file_priv";|971037|entityMap^0|1|5|0|0|7|E|0|0|0|1|6|0|0|P|B|1Y|6|0|0|0^^$0|@$1|2|3|4|5|6|7|13|8|@$9|14|A|15|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|16|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|17|8|@$9|18|A|19|B|M]]|D|@]|E|$]]|$1|N|3|O|5|H|7|1A|8|@]|D|@]|E|$I|J]]|$1|P|3|Q|5|6|7|1B|8|@]|D|@]|E|$]]|$1|R|3|S|5|6|7|1C|8|@$9|1D|A|1E|B|C]]|D|@]|E|$]]|$1|T|3|U|5|H|7|1F|8|@]|D|@]|E|$I|J]]|$1|V|3|W|5|6|7|1G|8|@$9|1H|A|1I|B|C]|$9|1J|A|1K|B|C]]|D|@]|E|$]]|$1|X|3|Y|5|6|7|1L|8|@]|D|@]|E|$]]|$1|Z|3|10|5|H|7|1M|8|@]|D|@]|E|$I|J]]|$1|11|3|-4|5|6|7|1N|8|@]|D|@]|E|$]]]|12|$]]

in Linux you have to edit my.cnf file in
<pre><code>/etc/mysql/my.cnf
</code></pre>
and change <code>26 line number</code> param like this :
<pre><code>secure-file-priv= &lt;your data path directory like /home/user/data&gt;
</code></pre>
then restart your MySQL and try again.
in docker
you have to mount your my.cnf file with my.cnf file in your container with this command in docker-compose or add manually :
<pre><code>volumes:
 - ./persistent:/var/lib/mysql
 - ./conf/my.cnf:/etc/mysql/my.cnf
</code></pre>
next change /conf/my.cnf in your host and config secure-file-priv param like the upper approach, in addition, you have to mount your data in mysql container and set that path for secure-file-priv param and restart your services and finally, you can load your data.
you can check your config with this command :
<pre><code>SHOW VARIABLES LIKE &quot;secure_file_priv&quot;;
</code></pre>

blocks|key|1521851|text|我在windows+10上遇到了这个问题。“--MySQL中的安全文件-priv”为了解决这个问题，我做了以下工作。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1521852|在windows搜索(左下角)中，我输入了"powershell“。|ordered-list-item|1521853|右键单击powershell并以管理员身份运行。|1521854|导航到服务器bin文件。(C:\Program+\MySQL\MySQL+Server+5.6\bin)；|1521855|打字/mysqld|1521856|按“进入”键|1521857|服务器按预期启动。|1521858|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$]]|$1|E|3|F|5|D|7|S|8|@]|9|@]|A|$]]|$1|G|3|H|5|D|7|T|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|U|8|@]|9|@]|A|$]]|$1|K|3|L|5|D|7|V|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|W|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|X|8|@]|9|@]|A|$]]]|P|$]]

I had this problem on windows 10. "--secure-file-priv in MySQL" To solve this I did the following. 

<ol>
<li>In windows search (bottom left) I typed "powershell". </li>
<li>Right clicked on powershell and ran as admin. </li>
<li>Navigated to the server bin file. (C:\Program Files\MySQL\MySQL Server 5.6\bin); </li>
<li>Typed ./mysqld</li>
<li>Hit "enter"</li>
</ol>

The server started up as expected.

blocks|key|356037|text|而不更改任何配置文件。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|356038|使用@vhu：SHOW+VARIABLES+LIKE+"secure_file_priv"发布的命令查找secure_file_priv的值。|ordered-list-item|offset|length|style|CODE|356039|定义查询的完整路径，如：select+*+from+table+into+outfile+'secure_file_priv_PATH/OUTPUT-FILE'+...+rest+of+your+query|356040|这适用于我在ubuntu18.04LTS+mysql+5.7.29上的mysql|356041|entityMap^0|0|7|12|1G|G|0|C|2J|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@$E|Q|F|R|G|H]|$E|S|F|T|G|H]]|9|@]|A|$]]|$1|I|3|J|5|D|7|U|8|@$E|V|F|W|G|H]]|9|@]|A|$]]|$1|K|3|L|5|6|7|X|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|N|$]]

Without changing any of the configuration files.. 

<ol>
<li>look for the value of <code>secure_file_priv</code> using the command posted by @vhu: <code>SHOW VARIABLES LIKE "secure_file_priv"</code>.</li>
<li>define the full path for your query such as: <code>select * from table into outfile 'secure_file_priv_PATH/OUTPUT-FILE' ... rest of your query</code></li>
</ol>

this worked for my in mysql-shell on ubuntu 18.04 LTS mysql 5.7.29

blocks|key|971062|text|我将LOCAL添加到命令中，但它产生了另一个问题：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|971063|Loading+local+data+is+disabled+-+this+must+be+enabled+on+both+the+client+and+server+sides|code-block|syntax|javascript|971064|为了解决这个问题，我简单地遵循了这里中的三个步骤|971065|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/59993844/error-loading-local-data-is-disabled-this-must-be-enabled-on-both-the-client^0|2|5|0|0|G|2|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@$9|V|A|W|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|X|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|Y|8|@]|D|@$9|Z|A|10|1|11]]|E|$]]|$1|M|3|-4|5|6|7|12|8|@]|D|@]|E|$]]]|N|$O|$5|P|Q|R|E|$S|T]]]]

I added the <code>LOCAL</code> to the command, but it made another problem:
<pre><code>Loading local data is disabled - this must be enabled on both the client and server sides
</code></pre>
For solving this I simply followed three steps in <a href="https://stackoverflow.com/questions/59993844/error-loading-local-data-is-disabled-this-must-be-enabled-on-both-the-client">here</a>

blocks|key|356241|text|以下是关于secure_file_priv的解释|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|356242|普雷夫|unordered-list-item|356243|下面是对LOAD+DATA的解释|356244|https://dev.mysql.com/doc/refman/8.0/en/load-data.html|356245|在我的例子中，来自正式Docker映像的MySQL正在使用中，所以我需要弄清楚如何设置secure_file_priv。|356246|为了更好地理解什么是secure_file_priv，我在上面的链接中读到了关于它的内容；|356247|读MySQL‘DockerHub要说的话，/mysql|356248|要知道(docker)+mysql的默认值：|356249|$+docker+run+-it+--rm+mysql+--verbose+--help
Variables+(--variable-name=value)
and+boolean+options+{FALSE%7CTRUE}++++++++++Value+(after+reading+options)
-----------------------------------------+-----------------------------
...
local-infile++++++++++++++++++++++++++++++FALSE
...
secure-file-priv++++++++++++++++++++++++++NULL
...|code-block|syntax|javascript|356250|实际上，(在容器中)配置文件中写着：|356251|root@a2b1e0c46541:/#+cat+/etc/mysql/my.cnf
#
#+(...license...)
#
#+The+MySQL++Server+configuration+file.
#
#+For+explanations+see
#+http://dev.mysql.com/doc/mysql/en/server-system-variables.html

[mysqld]
pid-file++++++++=+/var/run/mysqld/mysqld.pid
socket++++++++++=+/var/run/mysqld/mysqld.sock
datadir+++++++++=+/var/lib/mysql
secure-file-priv=+NULL

#+Custom+config+should+go+here
!includedir+/etc/mysql/conf.d/|356252|使用官方图像(如自述文件中所述)：|356253|$+docker+run+--name+mysql+-e+MYSQL_ROOT_PASSWORD=secret+-d+mysql+\
+++++++++--secure_file_priv=/data|356254|如果希望允许加载LOCAL+INFILE，还可以定义选项local_infile=TRUE。|blockquote|356255|现在您应该能够使用LOAD+DATA+INFILE+'/data/data.csv'+INTO+TABLE+some_table了。|356256|注意到：在相同的任务中--一旦解决了"INFILE“问题(上面)+--我的CSV数据中出现了空值问题，答案(和问题)非常有用：https://stackoverflow.com/a/5968530/687896。|BOLD|356257|entityMap|0|LINK|mutability|MUTABLE|url|https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_secure_file_priv|1|2|https://hub.docker.com/_/mysql|3|https://stackoverflow.com/a/5968530/687896^0|5|G|0|0|3|0|0|4|9|0|0|1I|1|0|17|G|0|A|G|0|L|6|2|0|0|0|0|0|0|0|8|C|S|H|0|9|1J|0|0|3|1R|16|3|0^^$0|@$1|2|3|4|5|6|7|1S|8|@$9|1T|A|1U|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|1V|8|@]|D|@$9|1W|A|1X|1|1Y]]|E|$]]|$1|I|3|J|5|6|7|1Z|8|@$9|20|A|21|B|C]]|D|@]|E|$]]|$1|K|3|L|5|H|7|22|8|@]|D|@$9|23|A|24|1|25]]|E|$]]|$1|M|3|N|5|6|7|26|8|@$9|27|A|28|B|C]]|D|@]|E|$]]|$1|O|3|P|5|H|7|29|8|@$9|2A|A|2B|B|C]]|D|@]|E|$]]|$1|Q|3|R|5|H|7|2C|8|@]|D|@$9|2D|A|2E|1|2F]]|E|$]]|$1|S|3|T|5|6|7|2G|8|@]|D|@]|E|$]]|$1|U|3|V|5|W|7|2H|8|@]|D|@]|E|$X|Y]]|$1|Z|3|10|5|6|7|2I|8|@]|D|@]|E|$]]|$1|11|3|12|5|W|7|2J|8|@]|D|@]|E|$X|Y]]|$1|13|3|14|5|6|7|2K|8|@]|D|@]|E|$]]|$1|15|3|16|5|W|7|2L|8|@]|D|@]|E|$X|Y]]|$1|17|3|18|5|19|7|2M|8|@$9|2N|A|2O|B|C]|$9|2P|A|2Q|B|C]]|D|@]|E|$]]|$1|1A|3|1B|5|6|7|2R|8|@$9|2S|A|2T|B|C]]|D|@]|E|$]]|$1|1C|3|1D|5|6|7|2U|8|@$9|2V|A|2W|B|1E]]|D|@$9|2X|A|2Y|1|2Z]]|E|$]]|$1|1F|3|-4|5|6|7|30|8|@]|D|@]|E|$]]]|1G|$1H|$5|1I|1J|1K|E|$1L|1M]]|1N|$5|1I|1J|1K|E|$1L|L]]|1O|$5|1I|1J|1K|E|$1L|1P]]|1Q|$5|1I|1J|1K|E|$1L|1R]]]]

Here is the explanation about <code>secure_file_priv</code>:
<ul>
<li><a href="https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_secure_file_priv" rel="nofollow noreferrer">https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_secure_file_priv</a></li>
</ul>
And here is the explanation of <code>LOAD DATA</code>:
<ul>
<li><a href="https://dev.mysql.com/doc/refman/8.0/en/load-data.html" rel="nofollow noreferrer">https://dev.mysql.com/doc/refman/8.0/en/load-data.html</a></li>
</ul>
In my case, MySQL from the official Docker image is in use, so I needed to figure out how to set <code>secure_file_priv</code>.
<ul>
<li>To understand better what is <code>secure_file_priv</code> I read the about it in the link above;</li>
<li>And read what MySQL' DockerHub had to say, <a href="https://hub.docker.com/_/mysql" rel="nofollow noreferrer">https://hub.docker.com/_/mysql</a></li>
</ul>
To know (docker) mysql defaults:
<pre class="lang-sh prettyprint-override"><code>$ docker run -it --rm mysql --verbose --help
Variables (--variable-name=value)
and boolean options {FALSE|TRUE} Value (after reading options)
----------------------------------------- -----------------------------
...
local-infile FALSE
...
secure-file-priv NULL
...
</code></pre>
In fact, (inside the container,) the config file says:
<pre><code>root@a2b1e0c46541:/# cat /etc/mysql/my.cnf
#
# (...license...)
#
# The MySQL Server configuration file.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html

[mysqld]
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
datadir = /var/lib/mysql
secure-file-priv= NULL

# Custom config should go here
!includedir /etc/mysql/conf.d/
</code></pre>
Using the official image (as explained in the README):
<pre class="lang-sh prettyprint-override"><code>$ docker run --name mysql -e MYSQL_ROOT_PASSWORD=secret -d mysql \
 --secure_file_priv=/data
</code></pre>
<blockquote>
If you want to allow <code>LOCAL INFILE</code> load, define also the option <code>local_infile=TRUE</code>.
</blockquote>
Now you should be able to <code>LOAD DATA INFILE '/data/data.csv' INTO TABLE some_table</code>.
NOTE: In the same task -- once the &quot;INFILE&quot; thing was solved (above) -- I had issues with empty values in my CSV data, to which the answer (and question) was very helpful: <a href="https://stackoverflow.com/a/5968530/687896">https://stackoverflow.com/a/5968530/687896</a> .

blocks|key|1522309|text|对于运行MacOS+5.6.23的MySQL+Mojave，我在编写文件时遇到了这个问题，但没有加载它们。(以前版本的Mac没有看到)。由于这个问题的大多数答案都是针对其他系统的，我想我应该发布一个my.cnf文件来解决这个问题(以及一个套接字问题)，以防它对其他Mac用户有帮助。我是/etc/my.cnf|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|1522310|[client]
default-character-set=utf8

[mysqld]
character-set-server=utf8
secure-file-priv+=+""
skip-external-locking|code-block|syntax|javascript|1522311|(国际化与问题无关。)|1522312|其他什么都不需要。只需关闭MySQL服务器，然后在首选项(我们正在讨论的是Mac)中再次打开即可。|1522313|entityMap^0|3Z|B|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@$9|R|A|S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|T|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|U|8|@]|D|@]|E|$]]|$1|M|3|N|5|6|7|V|8|@]|D|@]|E|$]]|$1|O|3|-4|5|6|7|W|8|@]|D|@]|E|$]]]|P|$]]

For MacOS Mojave running MySQL 5.6.23 I had this problem with writing files, but not loading them. (Not seen with previous versions of Mac OS). As most of the answers to this question have been for other systems, I thought I would post the my.cnf file that cured this (and a socket problems too) in case it is of help to other Mac users. This is /etc/my.cnf
<pre><code>[client]
default-character-set=utf8

[mysqld]
character-set-server=utf8
secure-file-priv = &quot;&quot;
skip-external-locking
</code></pre>
(The internationalization is irrelevant to the question.)
Nothing else required. Just turn the MySQL server off and then on again in Preferences (we are talking Mac) for this to take.

blocks|key|971166|text|我在这里也遇到了同样的问题，ERRORCODE+2。是的，大多数答案都是有意义的，但是我尝试了最简单的方法：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|971167|我在文件的路径中使用了双斜杠。|971168|我使用整个查询>>的示例路径尝试它，请让每个人知道它是否适合您。|971169|将数据本地INFILE+"E:\Irfan+One+Drive\OneDrive+-+Qtech\Documents\Suppliers\HB\Extended\HotelTransferZone.csv“加载到表temp_hb_transfer字段中，该字段由‘’可选地包围‘’”结尾|offset|length|style|CODE|971170|以“\n”结尾的行|971171|entityMap^0|0|0|0|2Z|G|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|S|8|@$H|T|I|U|J|K]]|9|@]|A|$]]|$1|L|3|M|5|6|7|V|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|O|$]]

I faced same issue here, ERRORCODE 2. Yes most of the answers do make sense, however I tried the simplest method :
I used double slashes in the path for the file.
my sample path with the entire query &gt;&gt; TRY IT and please let everyone know if it worked for you.
LOAD DATA LOCAL INFILE &quot;E:\Irfan One Drive\OneDrive - Qtech\Documents\Suppliers\HB\Extended\HotelTransferZone.csv&quot;
INTO TABLE <code>temp_hb_transfer</code>
FIELDS TERMINATED BY '|'
OPTIONALLY ENCLOSED BY '&quot;' 
LINES TERMINATED BY '\n'

I am learning MySQL and tried using a <code>LOAD DATA</code> clause. When I used it as below:

<pre><code>LOAD DATA INFILE "text.txt" INTO table mytable;
</code></pre>

I got the following error:

<blockquote>
 The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
</blockquote>

How do I tackle this error?

I have checked <a href="https://stackoverflow.com/questions/31951468/error-code-1290-the-mysql-server-is-running-with-the-secure-file-priv-option">another question on the same error message</a>, but still can’t find a solution.

I am using MySQL 5.6

How should I resolve --secure-file-priv in MySQL?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我正在学习MySQL，并尝试使用LOAD DATA子句。当我使用它时，如下：LOAD DATA INFILE "text.txt" INTO table mytable;我得到了以下错误：MySQL服务器运行时使用-secure-file-priv选项，因此无法执行此语句。如何处理此错误？我已经查过了，但还是找不到解决办法。我正在使用MySQL 5.6

问我应该如何在MySQL中解析--安全文件-优先级？
EN

回答 24

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问我应该如何在MySQL中解析--安全文件-优先级？EN

回答 24

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问我应该如何在MySQL中解析--安全文件-优先级？
EN