We are running a couple of shared host linux servers and a private one. We are running cPanel/WHM licenses under them.
The predicament I am facing is :
How can I run the following command automatically ?
mysqlcheck -u root -p --auto-repair --check --optimize --all-databases
The problem is that I am prompted for the root password, but I would like to run this command automatically and the password prompt intrerupts this process.
Please help me.