Eximstats Error : cPanel

Sometimes you may encounter with the following error(s) while checking Email Trace option in cPanel:

~~~~~~~~
Could not connect to mysql: Access denied for user 'eximstats'@'localhost' (using password: YES)
~~~~~~~~
Starting eximstats: DBI connect('eximstats:localhost','eximstats',...) failed: Access denied for user: 'eximstats@localhost'
(Using password: YES) at /usr/local/cpanel/bin/eximstats line 258
~~~~~~~~

Fix:

The reason behind this error, is an inaccuracy between the eximstats password for cPanel and the real password for the MySQL database. To resolve this, you will need to update the password 

for the eximstats user in MySQL using the following steps:

1. Initially check if eximstats is enabled at /var/cpanel/cpanel.config. 

2. If yes, you need to get the eximstats password from the file /usr/local/cpanel/etc/eximstats.sql. At the top of the file, u will see like that:

REPLACE INTO user (host, user, password)
VALUES (
'localhost',
'eximstats',
-- IMPORTANT: Change this password!
password('XXXXXXXXX')
);

Here, XXXXXXXXXX is the passowrd. Copy that password.

3. Login to mysql through root password and run the following queries:

mysql > update mysql.user set password=password("XXXXXXXXX") where user="eximstats";
mysql> flush privileges;
msyql> quit 

This will fix the error and you will no longer get a mysql connectivity problem. :)