List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:March 17 2000 3:56pm
Subject:Re: access denied when using mysqldump --tab
View as plain text  
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
>in mysqldump...


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
Thread
access denied when using mysqldump --tabSam Brauer17 Mar
  • access denied when using mysqldump --tabSam Brauer17 Mar
  • Re: access denied when using mysqldump --tabsinisa17 Mar
Re: access denied when using mysqldump --tabPaul DuBois17 Mar