MySQL table Import export failed--the MySQL server is running with the--SECURE-FILE-PRIV option

When you read this article, it is estimated that the problem is also a headache;

Import and export as a text file, found always error, a lot of solutions, the following is the simplest and thorough method, record.

First, locate the My.ini file in the C:\ProgramData\MySQL\MySQL Server xxx.xxx directory

Note here that Programdata is a hidden file, perhaps you set the hidden file is not visible, need to be temporarily set back: Tools--Folder Options, show hidden files

Search in the My.ini file Secure-file-priv find and change its value to

Secure-file-priv= ', that is, assignment is empty. (I am MySQL version 8.0):

It's not over yet, you need to restart MySQL;

Win+r input services.msc Everyone service interface, find your MySQL, restart can;

If not, then you can restart the computer to try, not to forget, do not export haha

MySQL table Import export failed--the MySQL server is running with the--SECURE-FILE-PRIV option