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'@'%

推荐答案

这是 MySQL 论坛上的一个主题，专门讨论了这一点.

这是答案，由 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屋！