mysql - Secure Priv Option Mysql 它是什么？

Question

我想了解 secure priv 选项是什么意思？我尝试在这个论坛上查找，但找不到任何内容..有人可以解释一下吗？

我尝试导入 csv 文件。现在一切都完成了，但需要了解我刚刚做了什么。

Answer 1

MySQL中的引用document

This variable is used to limit the effect of data import and export operations, such as those performed by the LOAD DATA and SELECT ... INTO OUTFILE statements and the LOAD_FILE() function. These operations are permitted only to users who have the FILE privilege.

secure_file_priv may be set as follows:

If empty, the variable has no effect.

If set to the name of a directory, the server limits import and export operations to work only with files in that directory. The directory must exist; the server will not create it.

If set to NULL, the server disables import and export operations. This value is permitted as of MySQL 5.7.6.