明明有select 權(quán)限卻報錯 mysql> select * from server into outfile '/tmp/tt.txt'; ERROR 1045 (28000): Access denied for user 'chenliang'@'%' (using password: YES)
百度后需要給file權(quán)限 mysql> grant file on *.* to chenliang; Query OK, 0 rows affected (0.00 sec)
導(dǎo)出成功 mysql> select * from server into outfile '/tmp/tt.txt'; Query OK, 27 rows affected (0.00 sec)
