Use a different directory for file loading: Instead of changing the secure-file-priv option, you can simply copy the file you want to load to a directory that is allowed by secure-file-priv. To do this, edit the my.cnf file, find the line that specifies secure-file-priv, and set it to a directory where you want to allow files to be loaded from, like:Īfter making this change, you’ll need to restart the MySQL server for the changes to take effect.Ģ.
0 Comments
Leave a Reply. |