Mysql 权限错误与“加载数据"

2021-11-20 00:00:00 mysql load-data-infile mysql-error-1045

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

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';

相关文章