The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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:
    6
    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:
    16
    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:
    16
    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