List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:December 15 1999 12:44pm
Subject:Re: Can't load data in file
View as plain text  
At 1:41 AM -0500 1999-12-15, Jeremy  A Horland wrote:
>Great! Thanks.
>
>Now, how do I set the FILE permission??
>
>Jeremy

A good place to start is by reading the description of the GRANT
statement in chapter 7 of the MySQL Reference Manual.


>  >At 12:58 AM -0500 1999-12-15, Jeremy  A Horland wrote:
>>>For some reason, when trying to "LOAD DATA IN FILE XXX INTO TABLE YYY", it
>>>gives me an "Access Denied" error for any user other than "root",
>>>regardless of grant tables and permissions..
>>>
>>>Anyone guess why??
>>
>>
>>No need to guess.  That means the only user on your system with the
>>FILE privilege is the root user.  You either need the FILE privilege,
>>or perhaps LOAD DATA LOCAL will do for you, since you can load files
>>that way whether or not you have the FILE privilege.
>>
>>--
>>Paul DuBois, paul@stripped


-- 
Paul DuBois, paul@stripped
Thread
Can't load data in fileJeremy A Horland15 Dec
  • Re: Can't load data in filePaul DuBois15 Dec
    • Re: Can't load data in fileJeremy A Horland15 Dec
      • Re: Can't load data in filePaul DuBois15 Dec
      • Re: Can't load data in filesinisa15 Dec
        • Re: Can't load data in fileJeremy A Horland15 Dec
  • inner join questionWangyue15 Dec