At 1:08 -0400 10/24/01, Avelino F wrote:
>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.
>At 10:09 PM 10/23/2001 -0500, you wrote:
>>At 10:43 PM -0400 10/23/01, Avelino F wrote:
>>>After logging into mysql and selecting a database, I type select *
>>>from song into outfile 'data123.txt'; but receive the following
>>>ERROR 1045: Access denied for user: 'avelino@localhost' (Using
>>>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.
Paul DuBois, paul@stripped