The default value of Secure-file-priv has been changed from 5.7.16, 5.6.34, 5.5.53 (Doc ID 2199657.1)

Last updated on DECEMBER 25, 2016

Applies to:

MySQL Server - Version 5.5 and later
Information in this document applies to any platform.

Symptoms

Batch application could be stopped after upgrade version (  5.7.16+ , 5.6.34+ , 5.5.53+ )

 

Changes

 The default value of  secure_file_priv has been changed to platform specific.

INSTALL_LAYOUT Value Default secure_file_priv Value
STANDALONE, WIN NULL
DEB, RPM, SLES, SVR4 /var/lib/mysql-files
Otherwise mysql-files under the CMAKE_INSTALL_PREFIX value

5.7 : https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_secure_file_priv

5.6 : https://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_secure_file_priv

5.5 : https://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html#sysvar_secure_file_priv

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms