In cPanel we have a script called /scripts/update_db_cache for recreating the DB cache. Sometimes when we try to update the dbcache we will get the below error.
warn [update_db_cache] Error while connecting to MySQL. Failover enacted. warn [update_db_cache] DBI connect(‘mysql:localhost’,’root’,…) failed: Access denied for user ‘root’@’localhost’ (using password: YES) at /usr/local/cpanel/Cpanel/Mysql.pm line 43
The resolution is available in the error itself. This issue may be due to incorrect password set for the root user. A resetting root password will help to resolve this issue