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