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.

Client Can't Access phpMyAdmin through cPanel

Discussion in 'Database Discussions' started by Jeff75, Oct 12, 2003.

  1. Jeff75

    Jeff75 Well-Known Member

    Joined:
    Apr 11, 2003
    Messages:
    555
    Likes Received:
    0
    Trophy Points:
    16
    One of my clients changed their MySQL database password today and now it's not letting them into their database through phpMyAdmin in cPanel. I have tried accessing other accounts and can view their databases, it's just this one account thats having problems. I've also tried restarting MySQL and cPanel and it's still showing this:

    Welcome to phpMyAdmin 2.5.2

    Wrong username/password. Access denied.

    Can somebody tell me how to fix this?

    cPanel.net Support Ticket Number:
     
  2. Jeff75

    Jeff75 Well-Known Member

    Joined:
    Apr 11, 2003
    Messages:
    555
    Likes Received:
    0
    Trophy Points:
    16
    Does anybody have any idea how to fix this??? I've also tried resetting the mysql root password and it didn't help. My client really needs to access his database!!

    cPanel.net Support Ticket Number:
     
  3. Angel78

    Angel78 Well-Known Member

    Joined:
    May 9, 2002
    Messages:
    413
    Likes Received:
    1
    Trophy Points:
    16
    I had the same issue, i think i got it solved by changing the root password for mysql.

    cPanel.net Support Ticket Number:
     
  4. moogle

    moogle Well-Known Member

    Joined:
    Apr 7, 2003
    Messages:
    94
    Likes Received:
    0
    Trophy Points:
    6
    Same problem. Changing root pass did not work.

    cPanel.net Support Ticket Number:
     
  5. PeterDB

    PeterDB Registered

    Joined:
    Mar 6, 2003
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Use the Password Modification feature in Web Host Manager to "reset" the password for the account.
     
  6. Jeff75

    Jeff75 Well-Known Member

    Joined:
    Apr 11, 2003
    Messages:
    555
    Likes Received:
    0
    Trophy Points:
    16
    It turned out that the problem was because I was logging in with the root password. You need to use the client's password in order to access phpMyAdmin through cPanel, which I wasn't aware of until the cPanel tech pointed this out.
     
  7. verdon

    verdon Well-Known Member

    Joined:
    Nov 1, 2003
    Messages:
    836
    Likes Received:
    2
    Trophy Points:
    18
    Location:
    Northern Ontario, Canada
    cPanel Access Level:
    Root Administrator
    I'm experiencing the same sorts of things... last night, all was well, today, phpMyAdmin refuses accept the username:password being passed by cpanel when a user is logged in.

    I've searched through the forums quite a bit, have tried the fix mentioned here as well as others, all to no avail.

    I'm using;

    WHM 8.5.4 cPanel 8.5.4-R72
    RedHat 8.0 - WHM X v2.1.1
    mysql (4.0.15-standard)
    phpMyAdmin 2.5.2

    I haven't installed anything or changed anything that I am aware of, from what was working fine for the last 2 weeks I've had this box.

    I don't seem I'm the only one encountering this, though some of the posts I've read are quite old and apply to earlier versions of cpanel.

    Is there a definitive fix?

    Thanks,
    verdon
     
  8. andyf

    andyf Well-Known Member

    Joined:
    Jan 7, 2002
    Messages:
    246
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    UK
    Anyone any success with what PeterDB suggests? Changing the account password using WHM can often resolve this.

    For the sake of others, please feed back here if you resolve it.
     
  9. verdon

    verdon Well-Known Member

    Joined:
    Nov 1, 2003
    Messages:
    836
    Likes Received:
    2
    Trophy Points:
    18
    Location:
    Northern Ontario, Canada
    cPanel Access Level:
    Root Administrator
    Hi Goal,

    I tried that too, to no avail...
     
  10. andyf

    andyf Well-Known Member

    Joined:
    Jan 7, 2002
    Messages:
    246
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    UK
    And can you access from the shell as the root user? (i.e. is your root pass working).

    Also, double check the permissions on databases in /var/lib/mysql
     
  11. verdon

    verdon Well-Known Member

    Joined:
    Nov 1, 2003
    Messages:
    836
    Likes Received:
    2
    Trophy Points:
    18
    Location:
    Northern Ontario, Canada
    cPanel Access Level:
    Root Administrator
    I'm pretty sure I can as I used shell to reset the root mysql word, following another tip I found in another thread.

    Permissions may be something though...

    One of the things I tried was a complete update of my cp and mysql. Sometime during this process, permissions did get messed on my httpd.conf file. Perhaps this is the case on the databases too?

    I'm running out of time tonight but will check those in the morning. What should the permisions be?

    TIA, verdon
     
  12. Angel78

    Angel78 Well-Known Member

    Joined:
    May 9, 2002
    Messages:
    413
    Likes Received:
    1
    Trophy Points:
    16
  13. verdon

    verdon Well-Known Member

    Joined:
    Nov 1, 2003
    Messages:
    836
    Likes Received:
    2
    Trophy Points:
    18
    Location:
    Northern Ontario, Canada
    cPanel Access Level:
    Root Administrator
    cPanel bug seems likely, as when I checked this morning (after auto-updates running last night) the problem has gone away?

    thanks all,
     
Loading...

Share This Page