Bug #112122 Can't rid off --secure-file-priv option on windows Env
Submitted: 21 Aug 2023 8:40 Modified: 21 Aug 2023 14:36
Reporter: Bruno BRACONNIER Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Windows Severity:S3 (Non-critical)
Version:8.0 OS:Windows
Assigned to: CPU Architecture:Any

[21 Aug 2023 8:40] Bruno BRACONNIER 
Description:
Hello Everyone,

I installed MySql Workbench 8.0 on Windows Server 2019 as testing environnement.

I'm stuck on message "ERROR: 1290: The MySQL server is running with the --secure-file-priv option so it cannot execute this statement", when trying to extract data from table to output file.
Using syntax like :
SELECT `Columns1`,`Colums2` from table INTO OUTFILE `F:\MySql\Tmp\File.csv`

I tried, I think, all kind of answers found on www.

Any Ideas, please.

Thank in advance for advices.
Bruno. 

How to repeat:

Using syntax like :
SELECT `Columns1`,`Colums2` from table INTO OUTFILE `F:\MySql\Tmp\File.csv`

Suggested fix:

I tried, I think, all kind of answers found on www.
[21 Aug 2023 13:08] MySQL Verification Team 
Hello Bruno,

Thank you for the bug report.
Imho this is duplicate of Bug #92372, please see Bug #92372.

Regards,
Ashwini Patil
[21 Aug 2023 14:36] Bruno BRACONNIER 
Hello Ashwini Patil,

Because my focuse was 'export to file', I haven't read topics about 'load data'...

That's work for me

Many thanks
Best regards.

Bruno.