[MySQL] LOAD INFILE Opcje

[termin]

jakie uprawnienia musi posiadać użytkownik aby mógł wykonać LOAD INFILE ?
u mnie działa to tylko na root, a uzytkownik nie mozę nic zrobić -> access denied.

[wookieb]

http://dev.mysql.com/doc/refman/5.1/en/load-data.html

For security reasons, when reading text files located on the server, the files must either reside in the database directory or be readable by all. Also, to use LOAD DATA INFILE on server files, you must have the FILE privilege. See Section 5.4.1, “Privileges Provided by MySQL”. For non-LOCAL load operations, if the secure_file_priv system variable is set to a nonempty directory name, the file to be loaded must be located in that directory.