MySQL set secure-file-priv to multiple directories

Question

Is there any way to allow MySQL to load data from multiple directories without setting secure-file-priv=''?

E.g., something like:

secure-file-priv="path/to/dir1","path/to/dir2"

From reading the docs, it isn't clear if multiple directories are allowed, and if so, how.

Answer 1

The short answer is no. You can only set a single location for secure-file-priv.

That said, every sub-directory of the configuration can be written to.

If you wanted to write anywhere on the system then you would configure it like this:

[mysqld]
secure-file-priv="/"

It's important to note that any file created by into outfile is writable by all users.