> 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/ >
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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]