Greetings to all users from a newcomer to this platform. I am facing the following situation:
- I have successfully installed MySQL Server 8.0 & MySQL Workbench on my work computer (which is of course managed by my employer company and hence local admin privileges were required for the installation); for the time being my scope of use is quite limited and thus one and the same machine will both host the server and act as the client
- I have also proceeded to create my first database together with an initial table, which is currently empty; so far everything went smooth
- the problem appeared though upon attempting to run
LOAD DATA INFILE
in order to upload a locally prepared csv file in the above-mentioned table: running the LOAD DATA
script produces the following:
Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement.
- Inspecting the secure-file-priv
variable revealed however that I had placed the respective csv file in the *correct* place - the path to the dedicated upload folder specified by this variable - and *I have also made sure* that I am referencing this correct path in the LOAD DATA
script. Nevertheless, the script will not execute: it appears as though for some reason the Server is oblivious of the actual location of the csv file and raises an error it should not!
I suspect this has a great deal to do with the fact that the computer is company managed and perhaps the server has insufficient local folder access privileges (?!).
If anyone of the more experienced users has encountered similar situations and could enlighten me on how to solve the above issue, I would be very grateful.
Thank you for your time!
Asked by ΑΘΩ
(101 rep)
Apr 16, 2025, 12:50 PM