Skip to main content

phpMyAdmin -- Welcome to phpMyAdmin

Comments

8 comments

  • Infopro
    I can access it under WHM, just not cPanel. I get the "Welcome to phpMyAdmin" message each time.

    Are you logged in as the cPanel user, in cPanel, when you try, or Reseller/root user?
    0
  • Fred90
    Are you logged in as the cPanel user, in cPanel, when you try, or Reseller/root user?

    I am logging in as the User. Let me try through as the root and see if that is any different.
    0
  • Fred90
    I am logging in as the User. Let me try through as the root and see if that is any different.

    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.
    0
  • cPanelMichael
    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.
    0
  • Fred90
    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.
    0
  • cPanelMichael
    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.

    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.
    0
  • Fred90
    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.

    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.
    0
  • cPanelMichael
    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.
    0

Please sign in to leave a comment.