MYSQL导出数据出现The MySQL server is running with the --secure-file-priv option
来源:互联网 发布:聚类分析数据 编辑:程序博客网 时间:2024/05/22 13:41
今天尝试使用 into outfile导出数据的时候出现错误:
The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
上网查了一下,应该是mysql设置的权限,可以使用
show variables like '%secure%';查看 secure-file-priv 当前的值是什么
导出的数据必须是这个值的指定路径才可以导出,默认有可能是NULL就代表禁止导出,所以需要设置一下
知道mysql安装路径下的my.ini文件,设置一下路径:
然后重启数据库即可;
阅读全文
0 0
- 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
- mysql 导出数据到文件 ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so
- MYSQL导入数据出现The MySQL server is running with the --secure-file-priv
- Error Code: 1290. The MySQL server is running with the --secure-file-priv option
- ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option
- mysql>导出数据为txt时报错:The MySQL server is running with the --secure-file-priv option so it cannot execut
- MySQL 报错Error Code: 1290. The MySQL server is running with the --secure-file-priv option
- mysql导出表到CSV文件方法及提示错误[Err] 1290 - The MySQL server is running with the --secure-file-priv option解决办法
- 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解决
- 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
- mysqldump: Got error: 1290: The MySQL server is running with the --secure-file-priv option so it can
- Error Code: 1290. The MySQL server is running with the --secure-file-priv op
- Windows下MySQL导入csv文件ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv opti
- MySQL 报错 ERROR 1290 (HY000): running with the --secure-file-priv
- js 点击小图旁边的大图跟着变
- CentOS7设置中文输入法
- 一个完整的ssm项目环境配置
- adb常用命令
- Django 用户系统相关的糖 占坑备用
- MYSQL导出数据出现The MySQL server is running with the --secure-file-priv option
- SpringMVC的请求流程图
- WSDL的文件结构(WSDL 1.1规范
- [POJ](1251)Jungle Roads ---最小生成树(图)
- ETL作业调度工具TASKCTL的两个重大突破
- eclipse显示代码行数
- MOOC清华《面向对象程序设计》第2章:左值引用实验
- Linux命令学习(centos6)
- Spring中<context:annotation-config/>的作用