mac mysql secure,如何处理MySQL服务器正在使用--secure-file-priv选项运行，因此它无法在Mac上执行此语句...

I'm looking to turn off secure-file-priv on mySQL 5.7.17. I've tried other suggestions for adding secure-file-priv="" to my.cmf, however mySQL refuses to start up afterwards:

bash-3.2# mysql

mysql: [ERROR] unknown variable 'secure-file-priv='

bash-3.2#

Other posts suggested secure_file_priv in stead but I get the same response from mySQL: unknown variable.

I've also tried adding --secure-file-priv=/path/to/folder to mySQL's launch daemon, but I get the same error.

Does anyone know how to turn this cumbersome feature off on the Mac version of mySQL?

Thank you!

解决方案

I had this error.

It was caused to variable in the wrong section.

It worked only when it under [mysqld]:

[mysqld]

secure_file_priv="/home"

Also, I noticed, that it wasn't working, when I tried to set it to empty string - it only worked, when it had actual path