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 password: YES)
>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