Restart MySQL and check: mysql> show variables like 'secure%' Use Xcode or for example BBEdit, and add line in section ProgramArguments On mac os x startup parameters of mysql You can change by edit. If I add -secure-file-priv=/mysql_exp to Daemons and reboot MySQL does not run at all.
In both cases after reboot I was still not allowed to write a file. No errors in logfiles, only in phpmyadmin (where I run the query statement from, logged in as root): same message as before. Then I run SELECT COLUMN_NAME, data_type INTO OUTFILE 'xpeter' FROM tabledefs I rerun the query without OUTFILE 'xpeter', query OK, no messages in log files except apache2 log. I run through whole filesystem, looking for any *.cnf file. usr/local/mysql/bin/mysqld -verbose -help | grep secure-file Variable stays as NULL: $bindir/mysqld_safe -datadir='$datadir' -pid-file='$mysqld_pid_file_path' -secure-file-priv='/tmp' $other_args >/dev/null & I tried to add -secure-file-priv='/tmp', no change. OUTFILE '/tmp/xpeter does not work either. When running this statement: SELECT COLUMN_NAME, data_type FROM tabledefs INTO OUTFILE 'xpeter' I get this message:ġ290 – The MySQL server is running with the –secure-file-priv option so it cannot execute this statement
I cannot find where to set secure-file-priv.
