How do I add the permission "LOAD FROM INFILE" to my database?

Suppose I did this:

CREATE DATABASE TEST; GRANT ALL ON TEST.* TO "user"@"%" IDENTIFIED开发者_如何学运维 BY "mypass";

How do I grant load from infile to "user"?

Try:

grant file on *.* to "user"@"%" identified by 'xxxx';

See http://dev.mysql.com/doc/refman/5.1/en/privileges-provided.html#priv_file