建立测试账号
(root@localhost) [mysql]>grant all privileges on test.* to "gf"@"%" identified by "gaofei";
使用测试账号登陆,并执行into outfile操作
(gf@localhost) [test]>select * into outfile '/home/mysql/itpub_a.dat' from itpub_A; ERROR 1045 (28000): Access denied for user 'gf'@'%' (using password: YES)
重新赋予file权限,提示该权限是global,必须使用*.*方式
(root@localhost) [mysql]>grant file on test.* to "gf"@"%"; ERROR 1221 (HY000): Incorrect usage of DB GRANT and GLOBAL PRIVILEGES (root@localhost) [mysql]>grant file on *.* to "gf"@"%"; Query OK, 0 rows affected (0.00 sec)
重新赋权后,再次执行into outfile成功导出
(gf@localhost) [test]>select * into outfile '/home/mysql/itpub_a.dat' from itpub_A; Query OK, 3 rows affected (0.00 sec)