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?
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