Re: Corn job anomaly

From: Date: Tue, 20 Sep 2016 08:10:09 +0000
Subject: Re: Corn job anomaly
References: 1 2 3 4  Groups: php.db 
Request: Send a blank email to php-db+get-49125@lists.php.net to get a copy of this message
> On Sep 20, 2016, at 3:06 AM, Lester Caine <lester@lsces.co.uk> wrote: > > On 20/09/16 06:16, Karl DeSaulniers wrote: >> Was probably a newb question, however, now it is saying that my database user is not >> allowed access. >> I have a mysql connection inside my script that reads the database to get user email >> addresses to send a reminder email to. >> >> Is there supposed to be a call or directive to load mysql in my command line as well? >> Man this is frustrating. > > The user name and password you are using from the web scripts SHOULD > work in the script you are using on the cron job. Although mysql does > seem to have a few extra security features that cut in. Are they listed > in the script, or loaded from the environment ... which is of cause > different for the cron jobs ... and why you needed the full path. > > -- > Lester Caine - G8HFL > ----------------------------- Hi Lester, They are listed inside the php file. The error message I get is: Access denied for user '(user name removed)'@'%' to database '(database name removed)' Thanks for your response. Best, Karl DeSaulniers Design Drumm http://designdrumm.com

« previous php.db (#49125) next »