mysql - 错误 1045 (28000) : Access denied for user 'usr' @'%' (using password: YES)

Question

我在尝试使用时收到以上错误消息:

SELECT * FROM mytable INTO OUTFILE /tmp/test.txt CHARACTER SET latin1 FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\r\n';

一个简单的选择查询工作正常:

mysql> select count(*) from mytable;
+----------+
| count(*) |
+----------+
|  1241551 |
+----------+
1 row in set (0.21 sec)

mysql>

Answer 1

这表示您没有该用户的FILE权限。请检查。