从 --secure-file-priv 文件夹导入 mysql，但仍然有错误

Question

我设置了 --secure-file-priv 如下:

mysql> show variables like '%secure%';
+--------------------------+----------+
| Variable_name            | Value    |
+--------------------------+----------+
| require_secure_transport | OFF      |
| secure_auth              | ON       |
| secure_file_priv         | E:\test\ |
+--------------------------+----------+

但是我得到了这样的错误:

D:\Tool\mysql-5.7.17-win32\bin>mysqlimport -u root -p my_test tb < e:test/new/outfile.sql
Enter password:
mysqlimport: Error: 1290, The MySQL server is running with the --secure-file-priv option so it cannot execute this statement, when using table: tb

另一个错误:

D:\Tool\mysql-5.7.17-win32\bin>mysqlimport -u root -p my_test tb < e:test\new\outfile.sql
Enter password:
mysqlimport: Error: 1290, The MySQL server is running with the --secure-file-priv option so it cannot execute this statement, when using table: tb

我应该怎么做才能解决这个问题？

Answer 1

事实是在my.ini中你没有指定正确的目录

安全文件隐私

secure-file-priv="F:/目录"