That sounds like the solution. Thanks for your help, everyone.
> The simplest solution is to keep the password in the .my.cnf file in > your home directory. See http://www.mysql.com/doc/en/Option_files.html > in the manual. > > In the case of root cron jobs then, you need a .my.cnf readable only by > root in root's home. It should include > > [client] > password="mysql_root_password" > > As mysql reads the .my.cnf file, this avoids the ps "sniffing" problem, > and also keeps the password out of the script. Because you make the > .my.cnf file readable only by root, other users can't see it. (If they > can see it, you've got bigger problems than just the mysql password). > > Michael -- Randall Perry sysTame Xserve Web Hosting/Co-location Website Development/Promotion Mac Consulting/Sales http://www.systame.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]