From: Ben Clewett
Date: February 20 2008 8:46am
Subject: Re: external mysqldump
List-Archive: http://lists.mysql.com/mysql/211429
Message-Id: <47BBE8E2.9070204@clewett.org.uk>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

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
>