- Original Message -
From: Simon Elliston Ball [EMAIL PROTECTED]
To: mysql@lists.mysql.com
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
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
[EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
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
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: mysql@lists.mysql.com
Sent: Wednesday, February 20, 2008 9:46 AM
Subject: Re: external mysqldump
Try:
mysql -u
.
- Original Message -
From: Ben Clewett [EMAIL PROTECTED]
To: Andre Hübner [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Wednesday, February 20, 2008 10:26 AM
Subject: Re: external mysqldump
I use a specific user (backup) for my backups, therefore user privileges
are not effected
, 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 Elliston Ball
[EMAIL PROTECTED]
On 20 Feb 2008, at 11:03, Andre Hübner wrote:
Unfortunately
- 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 'password';
That way each external user can only do super things