MySQL权限错误与'加载数据' [英] Mysql permission errors with 'load data'

问题描述

尝试将平面文件数据库转储中的数据加载到新表时遇到权限错误.我知道文件和表的架构相同，因此尝试调整权限.我还应该尝试什么?

I am running into a permission error when trying to load data from a flat file database dump into a new table. I know that the schema of the file and my table is the same and I tried tweaking the permissions. What else should I try?

mysql> load data infile 'myfile.txt' into table mytable fields terminated by ',' enclosed by '"';
ERROR 1045 (28000): Access denied for user 'user'@'%' 

grant all on mytable.* to 'user'@'%

推荐答案

Here's a thread on the MySQL forums that discusses exactly this.

这就是答案，肯·塔瑟尔(Ken Tassell)发布

Here's the answer, posted by Ken Tassell

使用以下命令解决问题:

Problem resolved using the command below:

grant file on *.* to kentest@localhost identified by 'kentest1';

这篇关于MySQL权限错误与'加载数据'的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！