Bug #92372 Error code: 1290 MySQL server running with --secure-file-priv option
| Submitted: | 11 Sep 2018 23:12 | Modified: | 12 Sep 2018 7:21 |
|---|---|---|---|
| Reporter: | Avinash Sorab | Email Updates: | |
| Status: | Not a Bug | Impact on me: | |
| Category: | MySQL Server: Security: Privileges | Severity: | S2 (Serious) |
| Version: | 8.0.12 | OS: | Windows |
| Assigned to: | CPU Architecture: | x86 |
[11 Sep 2018 23:12]
Avinash Sorab
[12 Sep 2018 7:21]
MySQL Verification Team
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Please ref https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_secure_file_pr... - strict secure_file_priv mysql> select @@secure_file_priv; +--------------------+ | @@secure_file_priv | +--------------------+ | NULL | +--------------------+ 1 row in set (0.00 sec) LOAD DATA INFILE 'D:\\MySQL\\fdef.txt' INTO TABLE test.datetimetest FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n'; WB: 12:35:27 LOAD DATA INFILE 'D:\\MySQL\\fdef.txt' INTO TABLE test.datetimetest FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n' Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement 0.062 sec CLI: mysql> LOAD DATA INFILE 'D:\\MySQL\\fdef.txt' INTO TABLE test.datetimetest -> FIELDS TERMINATED BY '\t' -> LINES TERMINATED BY '\n'; ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement mysql> ^^ If set to NULL, the server disables import and export operations. - less secure - secure_file_priv="" mysql> select @@secure_file_priv; +--------------------+ | @@secure_file_priv | +--------------------+ | | +--------------------+ 1 row in set (0.00 sec) WB: 12:42:03 LOAD DATA INFILE 'D:\\MySQL\\fdef.txt' INTO TABLE test.datetimetest FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n' 1 row(s) affected Records: 1 Deleted: 0 Skipped: 0 Warnings: 0 0.156 sec CLI: mysql> LOAD DATA INFILE 'D:\\MySQL\\fdef.txt' INTO TABLE test.datetimetest FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n'; Query OK, 1 row affected (0.15 sec) Records: 1 Deleted: 0 Skipped: 0 Warnings: 0 Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/ Thank you for your interest in MySQL.
[3 Jul 2019 6:18]
jitendra kumar
LOAD DATA INFILE 'C:/CDRS_Daily_2940_2019-06-24.csv' INTO TABLE aat_cdr24 FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n'; I GET THIS ERROR LOAD DATA INFILE 'C:/CDRS_Daily_2940_2019-06-24.csv' INTO TABLE aat_cdr24 FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n';
[21 Aug 2023 13:10]
MySQL Verification Team
Bug #112122 marked as duplicate of this one.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.041 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
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.