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
