Specify MySQL database user and password for Cron Job

[Cyburg <pa...@cyburg.co.uk>]

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.

Re: Specify MySQL database user and password for Cron Job

[Andreas Gies <an...@soa-knowledge.net>]

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.
>