List:General Discussion« Previous MessageNext Message »
From:Anand Kumar Date:April 29 2010 7:30am
Subject:Re: Recommend A Backup User / Privileges?
View as plain text  
Hi Carlos,


I would say the below grants for a user to perform backup is the minimum
grants which we can provide..

grant select , lock tables, file on *.* to backup_user'@'localhost'
identified by 'somepassword';

Thanks
Anand

On Wed, Apr 28, 2010 at 10:28 PM, Carlos Mennens <carloswill@stripped>wrote:

> I downloaded a MySQL backup script today since I have 3 or 4
> relatively small databases. The script can be found here:
>
> http://sourceforge.net/projects/automysqlbackup/
>
> Now I was wondering if I can create a local database user
> 'backup'@'localhost' & grant him a level of permissions needed to
> perform a 'mysqldump' so he can backup the databases to an directory
> on the server. My Question is what level or permissions does a user
> need to perform a 'mysqldump' on a database since that particular
> user's password will be entered into the script noted above via plain
> text. I am scared the password will be compromised & that would be bad
> if it's root or someone who has GRANT ALL PRIVILEGES ON *.*.
>
> Can you guys recommend something for me here? I don't really know
> enough about MySQL 'grant' permissions to determine which would work
> or if the 'backup' user would require high level privileges.
>
> -Carlos
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>

Thread
Recommend A Backup User / Privileges?Carlos Mennens28 Apr
  • Re: Recommend A Backup User / Privileges?Anand Kumar29 Apr
  • RE: Recommend A Backup User / Privileges?Bernd Lentes16 May