List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:October 24 2001 11:36pm
Subject:Re: into outfile error
View as plain text  
At 1:08 -0400 10/24/01, Avelino F wrote:
>Hello,
>
>I managed to set the file permission and managed to send the output 
>to the mysql database directory used. Do you know if there is a way 
>to make mysql write to a remote directory? Is there a global or 
>local configuration that can be specified where mysql will write to?

The server's doing the writing of the file, and it can only write the
file on the server host.  If you want the output written to a file on a
client host, you'll need to use a client program that issues the select and
writes the result to a file itself.

>Regards,
>Avelino
>
>At 10:09 PM 10/23/2001 -0500, you wrote:
>>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