List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:December 15 1999 6:10am
Subject:Re: Can't load data in file
View as plain text  
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
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