Eximstats error : unable to connect mysql access denied 'eximstats'@localhost

[Gaurav]

Hello,

If you face the following error in cpanel for email trace, follow below steps to resolve the problem.

could not connect to mysql access denied for user 'eximstats'@'localhost' (using password yes)

Follow the below steps to resolve this error.

Try resetting eximstats password with below command.

/usr/local/cpanel/bin/generate_eximstats_pass

It will reset and display new password for eximstats. Just in case you did not see new password you may get it with below command.

/usr/local/cpanel/bin/eximstatspass

It should resolve the error. If you still face the same error, reset the password manually from mysql with below steps.

First login into mysql with root privileges, after that run below commands.

(XXXXXXXXX) is the password you get with "/usr/local/cpanel/bin/eximstatspass"

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