How to remove --secure-file-priv in MySQL 5.7?

Question

MySQL

In my.ini file, I have this line commented out by default. But the error still comes out: The MySQL server is running with the --secure
-file-priv option so it cannot execute this statement

Answer 1

1. If empty, the variable has no effect. This is not a secure setting.
2. 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.
3. If set to NULL, the server disables import and export operations. This value is permitted as of MySQL 5.7.6.
Probably correct to set it as secure-file-priv="" or point to some existing directory

Answer 2

1. uncomment secure-file-priv and specify folder path as value. Upload files only from this folder
2. Use LOCAL. See https://dev.mysql.com/doc/refman/5.7/en/load-data.html for details

Answer 3

In /etc/my.cnf, in the [mysqld] section, add the line
AND restart mysqld:
service mysqld restart