List:General Discussion« Previous MessageNext Message »
From:Ben Clewett Date:February 20 2008 8:46am
Subject:Re: external mysqldump
View as plain text  
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