For a reason I've never understood, MySQL OS X installation defaults to no my.cnf. That causes endless problems. You can create one in /etc. There's a sample my.cnf in /usr/local/mysql/support-files/. Or in WorkBench ...
1 Open a connection
2 In the menu choose Instance -> 'Options File'
3 WB will search for it, and on failing to find it, WB will create it.
There are thousands of options. Read about them at
https://dev.mysql.com/doc/refman/8.0/en/option-files.html. You'll find secure_file_priv documented there. The value NULL blocks Load Data. Best secure practice is to set it to a custom folder.
If you don't have SUPER priv, is this a shared hosting arrangement? If so, you're not likely to be able to use Load Data.