mysqlopt throwing errors

[linux.newbie]

Getting the following message via email :

/etc/cron.weekly/mysqlopt:

/usr/bin/mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect

I have checked the /root/.my.cnf file and used the password listed there to update mysql password via WHM multiple times. Running the script manually via shell works fine. Please help.

Thanks

[linux.newbie]

please give me any leads

[dave9000]

Without seeing how /etc/cron.weekly/mysqlopt is done its hard to say why its not picking up the /root/.my.cnf info.

But a simple solution would be to add the host,user,pass,db info to the mysqlcheck statement inside the /etc/cron.weekly/mysqlopt file