Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Eximstats / MySQL problem - access denied

Discussion in 'General Discussion' started by jdan6@2003, Sep 19, 2003.

  1. jdan6@2003

    jdan6@2003 Active Member

    Joined:
    May 18, 2003
    Messages:
    32
    Likes Received:
    0
    Trophy Points:
    156
    After upgrading the MySQL last time via WHM, I changed the MySQL root password from Shell. Now when I restart Cpanel, I got the following error:

    -------------
    Starting eximstats: DBI connect('eximstats:localhost','eximstats',...) failed: Access denied for user: 'eximstats@localhost' (Using password: YES) at /usr/local/cpanel/bin/eximstats line 256
    Can't Connect at /usr/local/cpanel/bin/eximstats line 259.
    -------------

    I reset the root password via WHM again. But still got the same error message. Can someone suggest how to fix it?

    Thanks.

    cPanel.net Support Ticket Number:
     
  2. jsteel

    jsteel Well-Known Member

    Joined:
    Jul 4, 2002
    Messages:
    646
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    Atlanta, GA
    We're seeing a similar error:

    Sep 30 10:45:23 host43 starteximstats: DBI connect('eximstats:localhost','eximstats'
    ,...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql
    /mysql.sock' (2) at /usr/local/cpanel/bin/eximstats line 256
    Sep 30 10:45:23 host43 starteximstats: Can't Connect at /usr/local/cpanel/bin/eximst
    ats line 259.
    Sep 30 10:45:24 host43 cpanel: starteximstats startup failed

    cPanel.net Support Ticket Number:
     
  3. pagedeveloping

    pagedeveloping Well-Known Member

    Joined:
    Jun 11, 2003
    Messages:
    219
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    New York
    I found this when searching a while back when MySQL was down. So if it works for you lets bless the soul that came up with this.

    login via ssh

    run the commands as follows:

    killall mysqld
    safe_mysqld --skip-grant-tables &
    /usr/local/cpanel/startup

    Then login into WHM reset the MySQL root
    password.

    go back to ssh...

    killall mysqld
    /etc/rc.d/init.d/mysql start

    Hope this resolves your issue with MySQL. Doing it this way has always got it back up and running for me.

    cPanel.net Support Ticket Number:
     
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice