Resolved Cron and mysqlcheck

[sweetp]

I want to set a Cron job to optimise all my databases, so i tried running this command from a Scheduled Task:

mysqlcheck -uadmin -p`cat /etc/psa/.psa.shadow` --auto-repair --optimize --verbose --all-databases​

But it always throws an error:

Task "mysqlcheck -uadmin -p`cat /etc/psa/.psa.shadow` --auto-repair --optimize --verbose --all-databases" completed with error in 0 seconds, output:

cat: /etc/psa/.psa.shadow: Permission denied
Enter password: mysqlcheck: Got error: 1045: Access denied for user 'admin'@'localhost' (using password: NO) when trying to connect​

How can i set this Cron job, and have it run?

​

 

[sweetp]

So it was actually a pretty simple solution.
I was adding the task on a specific webspace.

When I re-aded the task in Tools & Settings > Scheduled Tasks as a root user, it ran just fine.