List:General Discussion« Previous MessageNext Message »
From:Andre Hübner Date:February 20 2008 11:03am
Subject:Re: external mysqldump
View as plain text  
Unfortunately, not. For internal uses i can use root or other special user. 
But if my users want to do backup on there own with external mysqldump they 
get this error.
if i do login with userdata from console i can do mysqldump, its only the 
external connect which makes this problem.

----- Original Message ----- 
From: "Ben Clewett" <ben@stripped>
To: "Andre Hübner" <Andre.Huebner@stripped>
Cc: <mysql@stripped>
Sent: Wednesday, February 20, 2008 10:26 AM
Subject: Re: external mysqldump


>I use a specific user (backup) for my backups, therefore user privileges 
>are not effected.  Is there something like this which you could use?
>
> Andre Hübner wrote:
>> Thank you for answering.
>> is there a way to do without granting super-privileg?  for security 
>> reasons i cannot grant too high privileges for normal db-users.
>> rights should be limited to own db.
>> Thanks
>> Andre
>>
>> ----- Original Message ----- From: "Ben Clewett" <ben@stripped>
>> To: "Andre Hübner" <Andre.Huebner@stripped>
>> Cc: <mysql@stripped>
>> Sent: Wednesday, February 20, 2008 9:46 AM
>> Subject: Re: external mysqldump
>>
>>
>>> Try:
>>>
>>> > mysql -u root -p ....
>>>
>>> mysql> GRANT SUPER ON *.* TO myuser@'%';
>>> mysql> GRANT SUPER ON *.* TO myuser@'localhost';
>>>
>>>
>>> Andre Hübner wrote:
>>>> Hi List,
>>>>
>>>> i wrote this alrready in mysql-forum a few days ago, but did not get 
>>>> any answer. :(
>>>>
>>>> i try to do backup with mysqldump from external host with routines.
>>>> mysqldump -R -h my.host.name -u myuser -p'mypass' mydb > filename.sql
>>>> I got error: myuser has insufficent privileges to SHOW CREATE FUNCTION 
>>>> `countuser`!
>>>> It works if i do the same mysqldumLine directly on the server where db 
>>>> is installed.
>>>> In mysql-table myuser has same privileges for % and locklhost. Are 
>>>> there some further restrictions for external connects?
>>>> I dont have an idea what to change now.
>>>>
>>>> Thank you
>>>> Andre
>>>>
>>
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1 

Thread
external mysqldumpAndre Hübner20 Feb
  • Re: external mysqldumpBen Clewett20 Feb
  • Re: external mysqldumpAndre Hübner20 Feb
    • Re: external mysqldumpBen Clewett20 Feb
  • Re: external mysqldumpAndre Hübner20 Feb
  • Re: external mysqldumpAndre Hübner20 Feb
    • Re: external mysqldumpSimon Elliston Ball20 Feb
  • Re: external mysqldumpAndre Hübner21 Feb