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