Running into the following error with the automated mysqlcheck script.
I am getting an access denied error when the script is run automatically. I've confirmed the root password and it is also set properly in /root/.my.cnf. I can run the command below using the password and it works correctly.
The error also occurs when proceeding to Repair a MySQL database in WHM. Is the script using a different password?
mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
mysqlcheck -u root -p --all-databases