unable to change secure_file_priv in my.cnf I have problems loading in a csv file, secure_file_priv is set to NULL, and that prevents me from reading in the csv file. I am trying to change secure_file_priv in my my.cnf file, but my changes don't go through.
mysql says:

Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf /usr/local/mysql/etc/my.cnf ~/.my.cnf 


so I made a my.cnf file in /etc, but the changes don't go through. (I restarted mysql server in mac preferences window)

this is what my file looks like:

[mysqld]
wait_timeout=28800
interactive_timeout = 28800
secure_file_priv=""
max_allowed_packet=64M


i edited my my.cnf file, restarted mysql server but when i use show variables like secure_file_priv it still says NULL, how can i alter the secure_file_priv option?
I do not know in Linux but in Windows 10/MySQL80 (my.ini instead of my.cnf) the option is spelled secure-file-priv  and not secure_file_priv. Do not forget to restart the service once the change is made.

I sadly lost one evening before finding my error. This is especially confusing as the SQL query to check the variable value is SELECT @@secure_file_priv.