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
Subject
Written By
Posted
Problem to set secure-file-priv using mysqld
February 09, 2021 11:58AM
February 09, 2021 02:45PM
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.