- Original Message -
From: "Simon Elliston Ball" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, February 20, 2008 1:13 PM
Subject: Re: external mysqldump
Ah!
What you actually need is for the users to have SELECT access to
mysql.procs.
GRANT SELECT ON mysql.procs TO user@'%
re Hübner" <[EMAIL PROTECTED]>
Sent: Wednesday, February 20, 2008 12:08 PM
Subject: Re: external mysqldump
GRANT SUPER ON userdatabase.* to user@'%' identified by 'password';
That way each external user can only do super things to their own db.
simon
Simon El
it?
Andre
- Original Message -
From: "Simon Elliston Ball" <[EMAIL PROTECTED]>
To: "Andre Hübner" <[EMAIL PROTECTED]>
Sent: Wednesday, February 20, 2008 12:08 PM
Subject: Re: external mysqldump
GRANT SUPER ON userdatabase.* to user@'%' identified by '
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
privileges for normal db-users.
rights should be limited to own db.
Thanks
Andre
- Original Message - From: "Ben Clewett" <[EMAIL PROTECTED]>
To: "Andre Hübner" <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, February 20, 2008 9:46 AM
Subject: Re: external mysql
o: "Andre Hübner" <[EMAIL PROTECTED]>
Cc:
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ü
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
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 F
