Windows下MySQL导入csv文件ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv opti
来源:互联网 发布:windows phone升级 编辑:程序博客网 时间:2024/06/04 18:56
出现错误的原因是导入文件所在目录不是安全目录。
修正方法
首先执行show variables like '%secure%';,查看MYSQL指定的安全目录在哪里。 查询结果中会有这样一条记录secure_file_priv | C:\ProgramData\MySQL\MySQL Server 5.7\Uploads\,该路径为安全路径,我们将需要导入的文件放在这个文件夹下面即可。 同样,导出文件的指定目录也要在该路径下面
但是我将文件放在目录下之后仍然报错,我将my.ini配置文件中加上“secure-file-priv=”不加安全路径重新启动MySQL,之后提示找不到文件。。。
后来发现是因为我在导入csv文件之前,使用了”use database”,这样应该将文件放在对应的database目录下,也就是“C:\ProgramData\MySQL\MySQL Server 5.7\Data”下面对应的数据库目录里。
阅读全文
0 0
- Windows下MySQL导入csv文件ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv opti
- ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option
- mysql 导出数据到文件 ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so
- ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot exec
- ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it ...statemet
- ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot exec
- MYSQL导入数据出现The MySQL server is running with the --secure-file-priv
- Error Code: 1290. The MySQL server is running with the --secure-file-priv op
- Error Code: 1290. The MySQL server is running with the --secure-file-priv option
- MySQL 报错 ERROR 1290 (HY000): running with the --secure-file-priv
- mysql导出表到CSV文件方法及提示错误[Err] 1290 - The MySQL server is running with the --secure-file-priv option解决办法
- mysqldump: Got error: 1290: The MySQL server is running with the --secure-file-priv option so it can
- MySQL 报错Error Code: 1290. The MySQL server is running with the --secure-file-priv option
- MYSQL导出数据出现The MySQL server is running with the --secure-file-priv option
- MYSQL导出数据出现The MySQL server is running with the --secure-file-priv option so it cannot execute this
- ubuntu 下Mysql导入导出文件报错:ERROR 1290 (HY000): --secure-file-priv
- The MySQL server is running with the --secure-file-priv option so it cannot execute this statement解决
- The MySQL server is running with the --secure-file-priv option so it cannot execute this statement解决
- Java 里如何实现线程间通信
- Redis安装
- mockito、powermock版本对应关系
- 10.15 loitest 未完
- 从win+ubuntu双系统安装到ubuntu环境配置和美化
- Windows下MySQL导入csv文件ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv opti
- 堆排序
- 内部类
- 洛谷10月月赛R1·浴谷八连测R1·提高组:SAC E#1
- java数据类型
- ActiveMQ五种消息类型生产消费
- 详解大端模式和小端模式
- 提高代码阅读能力的7种方法
- tensorflow中高级函数Experiment,Estimator,EstimatorSpec,DataSet