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!

Error while connecting to MySQL. Failover enacted.

Discussion in 'Database Discussion' started by dafut, Aug 4, 2010.

  1. dafut

    dafut Well-Known Member

    Joined:
    Dec 14, 2005
    Messages:
    75
    Likes Received:
    0
    Trophy Points:
    156
    Have one user, which is also the primary account, where that user cannot connect to mysql properly. For example: user_dbuser works to connect to user_db but "user" cannot connect to phpmyadmin without an error that says "Wrong username/password. Access denied."

    I've attempted to reset the user password, but also get an error on updating that users password in mysql (other passwords update properly).

    How can I fix the users access to mysql?

    Thanks.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. dafut

    dafut Well-Known Member

    Joined:
    Dec 14, 2005
    Messages:
    75
    Likes Received:
    0
    Trophy Points:
    156
    Resolved

    The issue turned out to be problems w one or more of the perl modules. Temporary fixes to a tailwatchd error (wouldn't load the eximstats driver, which caused a tailwatchd failure) were temporarily resolved by running "/scripts/upcp --force", yet the errors would return a few hours later.

    The support staff w the license provider provided me with the following suggestion:
    run these scripts:
    Code:
    /scripts/checkperlmodules --full --force
    /scripts/checkperlmodules --full
    /scripts/upcp --force
    After running the above, the affected user was able to access phpmyadmin. Time will tell if this also resolves the tailwatchd errors, although I suspect it will.

    Garrett @ NDC Hosting support provided me with the suggestion. Thanks Garrett. I do appreciate it!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
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