> 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
> 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