AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Where is mysql on mac5/5/2023 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
Read More
Leave a Reply. |