List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:October 24 2001 3:09am
Subject:Re: into outfile error
View as plain text  
At 10:43 PM -0400 10/23/01, Avelino F wrote:
>Hello,
>
>After logging into mysql and selecting a database, I type select * 
>from song into outfile 'data123.txt'; but receive the following 
>error message:
>
>ERROR 1045: Access denied for user: 'avelino@localhost' (Using password: YES)
>mysql>
>
>I made sure the user has full permissions to the database using the 
>grant command. Any suggestions on what can be wrong?

Said user might have full permissions on the database, but to use
SELECT INTO OUTFILE, you also need the FILE privilege, which is a
global privilege, not a database-specific one.  Most administrators
won't grant the FILE privilege lightly.

>
>Thanks,
>Avelino


-- 
Paul DuBois, paul@stripped
Thread
into outfile errorAvelino F24 Oct
  • Re: into outfile errorPaul DuBois24 Oct
    • Re: into outfile errorAvelino F24 Oct
      • Re: into outfile errorCarl Troein24 Oct
      • Re: into outfile errorPaul DuBois25 Oct
        • RE: into outfile errorChristopher Bergeron25 Oct