On Tue, 2007-06-19 at 13:08 +1000, Amos Shapira wrote: > You can specify the MySQL password on the command line with > "--password=supersecret" (not recommended if you have untrusted users > on that system - it'll be visible to "ps").
I always avoid doing that! > Another option (especially if you want to do this regularly) might be > to setup a MySQL user which can do this particular operation and allow > only root to login to that MySQL user without a password. I'm not sure > about the details but dig around, there is tons of documentation about > MySQL. > > You can get rid of the ssh password prompt by using private/public keys. Yeah sure. Thanks for all the comments. So I now have it working using a combination of SSH keys (I have a problem with it not working in .ssh/config but works if you specify the keyname on the command line with the -i option?!) and setting up the MySQL username/password in ~/.my.cnf as recommended by Michael Chesterton. -- Simon Wong <[EMAIL PROTECTED]> -- SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/ Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
