mysql 自写数据导出历时三天终于解决读取权限的问题

feleman

error 1 (hy000): Can't create/write to file '/root/100' (errcode: 13)
ERROR 1 (HY000): Can't create/write to file '\tmp\tutorials.txt' (Errcode: 2 - No such file or directory)
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement

以上触发的错误
解决办法
隐藏的文件夹打开C:\ProgramData\MySQL\MySQL Server 5.7
然后找到my.ini 请先复制一份并粘贴再修改
把my.ini变成my备份.ini
把my - 副本.ini改成my - 副本.txt
my - 副本.txt打开之后找到如下行

# Secure File Priv.
secure-file-priv="C:/ProgramData/MySQL/MySQL Server 5.7/Uploads"

改成
# Secure File Priv.
secure-file-priv=""

保存后关闭
my - 副本.txt改成my.ini

如果直接使用cmd 会得到这个结果
mysql>  select @@secure_file_priv ;
ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql>  select @@secure_file_priv ;
ERROR 2006 (HY000): MySQL server has gone away

不能直接所以一定要然后 win+r 输入services.msc 确定后得到服务窗口

在cmd进去你自己使用的数据包内找到 MySQL57 重启服务等上3分钟该服务器需要时间然后
mysql>  select @@secure_file_priv ;
+--------------------+
| @@secure_file_priv |
+--------------------+
|                               |
+--------------------+
1 row in set (0.00 sec)

得到上面的显示

mysql> SELECT * FROM runoob_tbl INTO OUTFILE 'target.txt';
Query OK, 4 rows affected (0.00 sec)

可以输出runoob_tbl一个target.txt文本