On 12/13/06, Bing Du <[EMAIL PROTECTED]> 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/22/mysql-backup-grant-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------
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
