明明有select 权限却报错 mysql> select * from server into outfile '/tmp/tt.txt'; ERROR 1045 (28000): Access denied for user 'chenliang'@'%' (using password: YES)
百度后需要给file权限 mysql> grant file on *.* to chenliang; Query OK, 0 rows affected (0.00 sec)
导出成功 mysql> select * from server into outfile '/tmp/tt.txt'; Query OK, 27 rows affected (0.00 sec)
