"Bing Du" <[EMAIL PROTECTED]> wrote:
> Thanks for the heads-up!
>
>> "Bing Du" <[EMAIL PROTECTED]> wrote:
>>>
>>> What I need to do is load data from a file into a table.
>>>
>>> mysql> load data infile
>>> '/home/user/LTM/generate_report.pl.ltm_enroll_tmp'
>>> into table ltm_enrollment fields terminated by '\t';
>>> ERROR 1045: Access denied for user: 'ltmuser'@'localhost' (Using
>>> password:
>>> YES)
>>>
>>> What privileges are needed for doing 'load data infile'?
>>
>> You must have FILE privilege.
>>
>
> I did not realize FILE privilege was not covered by 'grant all'.
>
Because FILE is a global level privilege:
GRANT FILE ON *.* TO 'ltmuser'@'localhost' IDENTIFIED BY 'secret';
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
