![]() You can copy example file from /usr/local/mysql/support-files/ You can achieve same result if will create my.cnf file straight in /etc/ sudo nano /etc/my.cnf 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |