account that can only do backup

#1 (**permalink**) 02-28-2008, 05:25 AM

Hi,

I want to create a MySQL user account that can only do database backup but
nothing else. What privileges does such an account need?

I'm having trouble with connecting to mysql.com to look at the documents.
It's just spinning forever. Actually, the connection to mysql.com has
become extremely slow since I noticed the mysql.com was redesigned.

Thanks in advance,

Bing

#2 (**permalink**) 02-28-2008, 05:25 AM

On 12/13/06, Bing Du <bdu@iastate.edu> wrote:
> Hi,
>
> I want to create a MySQL user account that can only do database backup but
> nothing else. What privileges does such an account need?
>
> I'm having trouble with connecting to mysql.com to look at the documents.
> It's just spinning forever. Actually, the connection to mysql.com has
> become extremely slow since I noticed the mysql.com was redesigned.
>

It all depends on HOW you're performing your backup, but using
mysqldump, I noticed that SELECT and LOCK TABLES is enough, and a
simple Google search confirmed that someone else thinks the same:

http://dannyman.toldme.com/2006/08/2...nt-privileges/

--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------

#3 (**permalink**) 02-28-2008, 05:25 AM

> On 12/13/06, Bing Du <bdu@iastate.edu> wrote:
>> Hi,
>>
>> I want to create a MySQL user account that can only do database backup
>> but
>> nothing else. What privileges does such an account need?
>>
>> I'm having trouble with connecting to mysql.com to look at the
>> documents.
>> It's just spinning forever. Actually, the connection to mysql.com has
>> become extremely slow since I noticed the mysql.com was redesigned.
>>
>
> It all depends on HOW you're performing your backup, but using
> mysqldump, I noticed that SELECT and LOCK TABLES is enough, and a
> simple Google search confirmed that someone else thinks the same:
>
> http://dannyman.toldme.com/2006/08/2...nt-privileges/
>

Thanks much for the response, Daniel. Sorry I did not make it clear in my
original post. Yes, you've read my mind. I use mysqldump. The pointer
you provided was very helpful. Appreciate it.

Bing

#4 (**permalink**) 02-28-2008, 05:25 AM

Hi,

File Privilege will do that. But the FILE privilege can only be granted globally (using ON *.* syntax).Therefore, attempts to restrict it to a particular scope will lead to error.

so try with
grant file on*.* to 'user'@'localhost';
Hope this will do.

Thanks
ViSolve DB Team
----- Original Message -----
From: "Bing Du" <bdu@iastate.edu>
To: <mysql@lists.mysql.com>
Sent: Thursday, December 14, 2006 12:26 AM
Subject: account that can only do backup

> Hi,
>
> I want to create a MySQL user account that can only do database backup but
> nothing else. What privileges does such an account need?
>
> I'm having trouble with connecting to mysql.com to look at the documents.
> It's just spinning forever. Actually, the connection to mysql.com has
> become extremely slow since I noticed the mysql.com was redesigned.
>
> Thanks in advance,
>
> Bing
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=m...rt@visolve.com
>
>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode