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 will > also be able to read it ). Or just run the backup script as root, and > then root can only read it ( you have to set the correct permissions > here too of course ).
What you really want to avoid is having the password on the commandline. File permissions won't matter at all if you end up running a command that puts your password in the output of 'ps'! Command lines are always public information. Put the password for mysqldump in the running user's ~/.my.cnf instead, and tighten the permissions on *that* file. [client] password=Your password goes here -Rich -- Rich Lafferty --------------+----------------------------------------------- Ottawa, Ontario, Canada | Save the Pacific Northwest Tree Octopus! http://www.lafferty.ca/ | http://zapatopi.net/treeoctopus.html [EMAIL PROTECTED] -----------+----------------------------------------------- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
