Cron Job - Access Denied Issue

[dpkyte]

I set up several cron Jobs and now am all of a sudden getting these error message that cannot connect to the database. seems like it started happening near March 23rd.

 

The job is to backup databases.

 

Got error: 1044: Access denied for user

 

this is happening not in 1 of my sites, but several of them. It is a standard job that has been running for a long time, has anyone else came accross this issue?

 

Has there been any system changes that caused this?

 

Thanks,

 

DPK

[TweezerMan]

The "Error 1044" appears to be an "database access denied" error reported by the MySQL server. This error is normally reported as "Access denied for user 'db_username' to database 'my_database'".

 

I'd suggest checking your database in CPanel / MySQL Databases and make sure that everything is still set up correctly (database exists, username exists, username is added to database), and check your cron jobs / scripts to make sure they are still using the correct username / password to connect to the MySQL server.

[dpkyte]

I checked, double checked, triple checked and ..... this. Not sure what all happened here but I am a reseller and the same thing happened to 4 different sites that I run a similiar cron job for. The thing is they all started having issues at the same time frame.

[dpkyte]

Not sure what happened, however it seemed as though the permissions changed and needed access to LOCK the tables. I changed permissions and all is fine.

 

Thx for the help.