MySQL Forums
Forum List  »  Newbie

Problem to set secure-file-priv using mysqld
Posted by: Albert B
Date: February 09, 2021 11:58AM

I'm trying to use it
LOAD DATA INFILE 'C:\ProgramData\MySQL\MySQL Server 8.0\Uploads\Center.CSV' INTO TABLE Center
FIELDS TERMINATED BY ';' ENCLOSED BY '"'
LINES TERMINATED BY '\r\n';

but doesn't work, below i appended my global variable, i don't understand what's wrong


this is what's happen if inside mysql i type show variables like 'secure_%';

| secure_file_priv | C:\ProgramData\MySQL\MySQL Server 8.0\Uploads\ |

but if i do it using mysqld.exe --verbose --help

secure-file-priv NULL

Options: ReplyQuote


Subject
Written By
Posted
Problem to set secure-file-priv using mysqld
February 09, 2021 11:58AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.