Hi, I am new to MySQL and have one question. I would like to run mysql job as a batch job (scheduled through cron) and have to provide password to the batch job: mysql -udba -ppassword My concern that anybody running: ps -ef will be able to see the password when job is run. Is there any way to run mysql as a batch job with mysql -udba -p and pump a password from inside your script. Something like: mysql -udba -p << EOF < .hidden_pwd_file use mysql select * .... EOF I've tried a few things but I am out of ideas. Any help would be appreciated. Alek
--------------------------------- Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger