Chinaunix首页 | 论坛 | 博客
  • 博客访问: 1059866
  • 博文数量: 186
  • 博客积分: 4939
  • 博客等级: 上校
  • 技术积分: 2075
  • 用 户 组: 普通用户
  • 注册时间: 2010-04-08 17:15
文章分类

全部博文(186)

文章存档

2018年(1)

2017年(3)

2016年(11)

2015年(42)

2014年(21)

2013年(9)

2012年(18)

2011年(46)

2010年(35)

分类: Mysql/postgreSQL

2011-12-02 13:23:54

I run into a permission error when trying to load data into mysql .

To read a file with LOAD DATA INFILE from the server, the user needs FILE privilege, and I don't think that's granted by default when you use "ALL" - grant that privilege and you should be fine.

For security reasons, when reading text files located on the server, the files must either reside in the database directory or be readable by all. Also, to use LOAD DATA INFILE on server files, you must have the FILE privilege. See Section 5.4.1, “Privileges Provided by MySQL”. For non-LOCAL load operations, if the secure_file_priv system variable is set to a nonempty directory name, the file to be loaded must be located in that directory.
阅读(1449) | 评论(0) | 转发(0) |
0

上一篇:fold,gsub语法

下一篇:dump/load mysql-ib databases

给主人留下些什么吧!~~