MySQL Forums
Forum List  »  MySQL Workbench

LOAD DATA security error
Posted by: Randy Park
Date: May 14, 2019 09:42AM

New to MySQL. Used 5 different RMDBMS' 20 years ago on OpenVMS OS. Using Windows 8.1, MySQL Server 8, and Workbench.

Attempting to migrate a Hiking Log database for our hiking club into MySQL.
Successfully created Schema, Tables, Indexes, Constraints. Exported 1 table from old database into CSV file. Now wanting to load CSV file into table.

When using LOAD TABLE command I get security error 1290 regarding 'secure-file-priv' option. Using workbench, I change that option. Realize I need to restart server, I use workbench to stop server. Server attempts to stop but WON'T stop. Shut down Windows and restart. Inspect options using workbench, secure-file-priv is now turned off. Attempt LOAD command again. Same error.

Uninstall MySQL. Find files still out there. Delete files manually. Install MySQL, but encounter error this time. Service name "MySQL80" already used. Create new service "MySQL80a". Install finishes.

Start workbench. Connect to server. create schema, tables, etc again. Change secure-file-priv option. Apply change. Reboot Windows. Start workbench again. Confirm option is changed. Attempt LOAD command. Get security error 1290 again. Try to stop server, won't stop.


Options: ReplyQuote

Written By
LOAD DATA security error
May 14, 2019 09:42AM
May 14, 2019 09:54AM
May 16, 2019 09:40AM
May 16, 2019 10:01AM

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.