MilesWeb
MilesWeb Hosting Forum

Please login or register.

Login with username, password and session length

 

News:

SMF - Just Installed!


Author Topic: Eximstats error : unable to connect mysql access denied 'eximstats'@localhost  (Read 3938 times)

0 Members and 1 Guest are viewing this topic.

Offline Gaurav

  • Newbie
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Hello,

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

Quote
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.
Quote
/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.
Quote
/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"
Quote
mysql > update mysql.user set password=password("XXXXXXXXX") where user="eximstats";
mysql> flush privileges;
msyql> quit   

MilesWeb Hosting Forum