So, I have a problem with importing data from files(csv files, particularly) due to secure-file-priv restricting me from importing data.
In order to see the location of the option file directory, there is an MySQL script
SHOW VARIABLES LIKE "secure-files-priv";
The output it gives me is the following:
Empty set (0.00 sec)
This lead me to many similar stack-overflow forum pages, where I have found multiple solutions, none of which actually worked.
There is this (Location of my.cnf file on macOS) question, where mysql workbench does not actually generate anything and i am just stuck with the "Location of MySQL configuration file (ie: my.cnf) not specified" screen.
I have checked all possible locations, none of which seem to work.
Somebody, anyone, I need help, I have spent way too much time on this seemingly easily-solvable issue.
