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
