At 5:11 PM -0500 03-16-2000, Sam Brauer wrote:
>Here's my problem:
>I can successfully run the following command as root:
>mysqldump --tab=dump -u root -p mydatabase
>But if I'm using my normal non-root login and run:
>mysqldump --tab=dump -u myusername -p mydatabase
>I get the following error:
>mysqldump: Got error: 1045: Access denied for user: 'myusername@localhost'
>(Using password: YES)
>Note that myusername has been granted all permissions on mydatabase.*
>and the following commands work just fine:
>mysqldump -d -u myusername -p mydatabase
>mysql -u myusername -p mydatabase
>Anybody encountered this problem using the --tab option of mysqldump?
>I need to avoid running this as root. Plus it seems like it may be a bug
You may have all the privileges on your database, but you must also
have the FILE privilege to use the --tab option, and that's a global
privilege. Most administrators will grant this only to superusers,
so that may be your problem.
Paul DuBois, paul@stripped