Solve the problem of secure-file-priv option when importing and exporting mysql data

Mysql database imports or exports from a file to a file, prompting The MySQL server is running with the --secure-file-priv option so it cannot execute this statement. The reasons and solutions are as follows:

Some versions of mysql have restrictions on import and export through files, which are not allowed by default.

View the configuration and execute the mysql command

Subscribe to Permissions