How can I resolve the \'Error Code: 1290: The MySQL server is running with the --secure-file-priv option\' error?

Error Encountered: Secure File Permission Restriction

The MySQL error "Error Code: 1290. The MySQL server is running with the --secure-file-priv option" arises when the MySQL server has the "--secure-file-priv" option enabled, restricting the execution of statements that involve reading or writing from specific directories.

To address this issue, you have several options:

Restrict File Access to Secure Directory:

You can configure the MySQL server to only allow file access to a specific secure directory, designated in the "secure_file_priv" variable. Use the "SHOW VARIABLES LIKE 'secure_file_priv';" command to view the current directory. Once the secure directory is known, ensure that your "INTO OUTFILE" statement specifies this directory.

Disable Secure File Permission:

If you are running a test or non-production environment, you may disable the "--secure-file-priv" option by editing the MySQL configuration file (e.g., my.ini on Windows). Comment out the "secure-file-priv" setting within the "[mysqld]" group and restart the MySQL service. Remember to re-enable the option later for increased security.

Specify Custom Secure Directory:

You can define a custom secure directory by setting the "secure_file_priv" variable to the path of your desired directory. This approach allows you to control file permissions more granularly.

Alternative Solution for Windows:

For Windows users, an alternative to modifying configuration files is to use the "C:/ProgramData/MySQL/MySQL Server 5.6/Uploads" directory. By default, the "secure-file-priv" option is configured with this directory. Specify this directory in your "INTO OUTFILE" statement to bypass the error.

By following these steps, you can resolve the "Error Code: 1290" and enable the use of the "INTO OUTFILE" statement with appropriate file permissions.

The above is the detailed content of How can I resolve the \'Error Code: 1290: The MySQL server is running with the --secure-file-priv option\' error?. For more information, please follow other related articles on the PHP Chinese website!