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!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

phpMyAdmin -- Welcome to phpMyAdmin

Discussion in 'Database Discussions' 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,066
    Likes Received:
    348
    Trophy Points:
    433
    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?
     
  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:
    42,734
    Likes Received:
    1,706
    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.
     
  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:
    42,734
    Likes Received:
    1,706
    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.
     
  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:
    42,734
    Likes Received:
    1,706
    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.
     
Loading...

Share This Page