RE: Recommend A Backup User / Privileges?

2010-05-16 Thread Lentes, Bernd
Carlos mennens wrote: > > 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. > Hi, Set the

Recommend A Backup User / Privileges?

2010-04-29 Thread Carlos Mennens
I downloaded a MySQL script that backs up all my databases automatically which looks to work amazing. My question is in this particular script (linked below) there is a section to add a user name and password for someone who has access to the databases I am attempting to backup with the script. Now

Re: Recommend A Backup User / Privileges?

2010-04-29 Thread Anand Kumar
lar > 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&#

Recommend A Backup User / Privileges?

2010-04-28 Thread Carlos Mennens
ed 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 whi

Re: Backup User

2005-02-23 Thread Jim McAtee
- Original Message - From: "Daniel Kasak" <[EMAIL PROTECTED]> To: "Jim McAtee" <[EMAIL PROTECTED]>; Sent: Wednesday, February 23, 2005 2:39 PM Subject: Re: Backup User Jim McAtee wrote: Is it recommended to create a MySQL user for doing backups? Runni

Re: Backup User

2005-02-23 Thread Rich Lafferty
On Thu, Feb 24, 2005 at 08:39:00AM +1100, Daniel Kasak <[EMAIL PROTECTED]> wrote: > You don't need to create a special MySQL user for backups. If you like, > you can create a Linux account that only you know the password to, and > then make sure the backup scripts is only readable by you ( root

Re: Backup User

2005-02-23 Thread Daniel Kasak
Jim McAtee wrote: Is it recommended to create a MySQL user for doing backups? Running mysqldump from a script, the username and password will have to be embedded in plain text. If I were to create a MySQL user expressly for doing nightly backups what are the minimum permissions needed? You d

Backup User

2005-02-23 Thread Jim McAtee
Is it recommended to create a MySQL user for doing backups? Running mysqldump from a script, the username and password will have to be embedded in plain text. If I were to create a MySQL user expressly for doing nightly backups what are the minimum permissions needed? -- MySQL General Mailing

mysql backup user permissions?

2002-11-07 Thread Shon Stephens
i want to add a user to my system that has permissions to backup all the databases using mysqlhotcopy. i don't want to use the root user. so what permissions (minium set) should i give the user in order to accomplish this. thanks in advance, shon --