LOAD DATA security error
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.
Suggestions?
Subject
Views
Written By
Posted
LOAD DATA security error
1045
May 14, 2019 09:42AM
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.