SELECT * INTO OUTFILE doe not work on Windows

[Wei Jiang]

Hi,

On Windows 10, I am trying to call:
SELECT * INTO OUTFILE 'D:\mysql_secure_file_priv\tournament.csv'
FIELDS TERMINATED BY '\t' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM tournaments
WHERE id = 'something';

and got error:ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv .
I defined the property and checked:
+------------------+-------+
| Variable_name | Value |
+------------------+-------+
| secure_file_priv | NULL |
I changed the value to other existing dir, but still get the same error.
I also ties to assign the value to an empty string: the same error.

I tried on Ubuntu, It works there.

What is wrong on my side?
Mysql version I use is: Server version: 8.0.21 MySQL Community Server

Any information would be appreciated. Thanks in advance.