You may also want to make sure that you did: flush privileges; to make sure they are implemented.
-----Original Message----- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 24, 2001 7:36 PM To: Avelino F Cc: [EMAIL PROTECTED] Subject: Re: into outfile error 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, [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
