List:General Discussion« Previous MessageNext Message »
From:Andre Hübner Date:February 20 2008 9:00am
Subject:Re: external mysqldump
View as plain text  
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
>> 

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