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
