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!

phpMyAdmin -- Welcome to phpMyAdmin

Discussion in 'Database Discussion' started by Fred90, Dec 28, 2017.

Tags:
  1. Fred90

    Fred90 Member

    Joined:
    Aug 24, 2017
    Messages:
    14
    Likes Received:
    3
    Trophy Points:
    3
    Location:
    Ontario, Canada
    cPanel Access Level:
    Root Administrator
    I am no longer able to access "phpMyAdmin" when clicking on it under the cPanel Dashboard. I can access it under WHM, just not cPanel. I get the "Welcome to phpMyAdmin" message each time.

    I contacted the company I use to host the server with. They are able to access it. I can't. I cleared all cookies and cache and tried 4 different browsers -- all the same results, no access.

    This all began directly after the password for that cPanel account was changed. I read through all the different solutions within the forums and nothing is resetting this.

    It is almost as if the IP address for my PC is locked out or storing something with the server as the hosting company checked and is informing me they do access to it.

    Is there a fix or solution for this?
     
  2. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    16,309
    Likes Received:
    393
    Trophy Points:
    583
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    Are you logged in as the cPanel user, in cPanel, when you try, or Reseller/root user?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. Fred90

    Fred90 Member

    Joined:
    Aug 24, 2017
    Messages:
    14
    Likes Received:
    3
    Trophy Points:
    3
    Location:
    Ontario, Canada
    cPanel Access Level:
    Root Administrator
    I am logging in as the User. Let me try through as the root and see if that is any different.
     
  4. Fred90

    Fred90 Member

    Joined:
    Aug 24, 2017
    Messages:
    14
    Likes Received:
    3
    Trophy Points:
    3
    Location:
    Ontario, Canada
    cPanel Access Level:
    Root Administrator
    That works; I am able to sign in and access phpMyAdmin and why the hosting company is able to access it. It is still an issue signing in directly through cPanel though.

    Would be nice to have that working again so that I don't have to give access to the WHM.
     
    #4 Fred90, Dec 28, 2017
    Last edited: Dec 28, 2017
  5. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,378
    Likes Received:
    1,857
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    Can you verify if skip_name_resolve is enabled in the /etc/my.cnf file on this server? If not, check the account's home directory (/home/$username) to see if a .my.cnf file exists. If so, you can remove this file so that cPanel uses the account password.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  6. Fred90

    Fred90 Member

    Joined:
    Aug 24, 2017
    Messages:
    14
    Likes Received:
    3
    Trophy Points:
    3
    Location:
    Ontario, Canada
    cPanel Access Level:
    Root Administrator
    Got it resolved -- don't if this is a bug or not. When a password is changed shouldn't it update FTP (which it did), cPanel (which it did) as well as MySQL? It didn't get updated. I was looking around in the WHM and found this. Home » SQL Services » Change MySQL User Password. I changed the password to match what should have been taken care of. Once I did all is accessible.
     
  7. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,378
    Likes Received:
    1,857
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    Check the account's home directory (/home/$username) to see if a .my.cnf file exists. This file defines a specific MySQL password and can lead to a mismatched cPanel and MySQL password if the cPanel password is changed.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  8. Fred90

    Fred90 Member

    Joined:
    Aug 24, 2017
    Messages:
    14
    Likes Received:
    3
    Trophy Points:
    3
    Location:
    Ontario, Canada
    cPanel Access Level:
    Root Administrator
    I don't see that file at all. Should it be there? I don't want to mess with my server; but I can inform hosting company that manages the servers.
     
  9. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,378
    Likes Received:
    1,857
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    No the file does not exist by default. It's existence can sometimes explain why phpMyAdmin fails to load after a cPanel password change. The other thing to check is if skip_name_resolve is enabled in the /etc/my.cnf file. This option is unsupported, and should be disabled.

    Thank you.
     
    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