Hi there,
I am wondering if you hit the correct mailing list ?
This having said, you can create a user specific crontab and execute
your job in there.
If you are using the mysql command line use, the -u and -p parametes
in your cronjob spec.
HTH
Andreas
On May 6, 2009, at 3:34 PM, Cyburg wrote:
Hi all,
Does anyone here know if it is possible to specify which database
user and
password my Cron Job will use when accessing a MySQL database.
My code accesses the My SQL database in question from a PHP page,
which
contains defines to specify the database user and password to use;
when I
navigate to the page in question using a browser, the code executes as
expected.
However, when I execute the page as a Cron Job, the page fails (I
see this
in the email report the server sends me) with error messages that
would
suggest that the Cron Job is trying to use the root account with no
password
to access the database.
How do I specify which database account my Cron Job should use?
Cheers,
Paul
--
View this message in context:
http://www.nabble.com/Specify-MySQL-database-user-and-password-for-Cron-Job-tp23406829p23406829.html
Sent from the ActiveMQ - User mailing list archive at Nabble.com.
