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!

Wrong username/password. Access denied phpmyadmin

Discussion in 'Database Discussion' started by vishal3184, Feb 3, 2011.

  1. vishal3184

    vishal3184 Registered

    Joined:
    Feb 3, 2011
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    51
    Hi All,

    I am newbie to cPanel. I have a created a database using phpMyAdmin which has 3 tables.

    Today morning i have reset my cPanel's password and unfortunately i am not able to see 2 tables of my database. It gives me an error of "Wrong username/password. Access denied." (I can see one of the table in database)

    Thanks in advance.
     
    #1 vishal3184, Feb 3, 2011
  2. forum17

    forum17 Active Member

    Joined:
    Mar 30, 2007
    Messages:
    29
    Likes Received:
    0
    Trophy Points:
    151
    Please try reseting the password for the cpanel account and check.

    If that do not works, you can try executing the below script

    /scripts/grabmysqlprivs

    If you are still having issues then the issue could be mysql password is not reset even if we reset the cpanel password. In this case you need to update the mysql password for the user from the shell to that of changed cpanel password.

    mysql> update user set password=PASSWORD("pass") where user='user';
    mysql> flush privileges;

    Regards,
    host.co.in
     
    #2 forum17, Feb 3, 2011
  3. coderiser

    coderiser Member

    Joined:
    Jan 31, 2011
    Messages:
    18
    Likes Received:
    0
    Trophy Points:
    51
    go in your whm and reset the root mysql password
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #3 coderiser, Feb 3, 2011
  4. cPanelTristan

    cPanelTristan Quality Assurance Analyst Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,608
    Likes Received:
    33
    Trophy Points:
    238
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    Resetting the root MySQL password would not correct the cPanel user's password not working for accessing tables in a database. I would suggest resetting the cPanel password again and ensuring that "Allow MySQL password change" is checked when changing the password.

    If it is and you are still having issues, go to your root directory for that user (/home/username) and check for a .my.cnf file there. If there is one, check that the password listed is the same as the new password you've used for MySQL and cPanel. If it is not the same, change to the right password.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 cPanelTristan, Feb 3, 2011
  5. cyberdyne

    cyberdyne Member

    Joined:
    Jun 23, 2011
    Messages:
    18
    Likes Received:
    0
    Trophy Points:
    51
    Is the password that is contained within the '.my.cnf' file meant to only control only MySQL access? I ask as I have a different passwords for my cPanel login and phpMyAdmin, and I've also noticed that the password within the '.my.cnf' file is different again to the two others.

    Thanks
     
    #5 cyberdyne, Jun 27, 2012
  6. cPanelTristan

    cPanelTristan Quality Assurance Analyst Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,608
    Likes Received:
    33
    Trophy Points:
    238
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    The .my.cnf in /home/username handles MySQL database logins for PHPMyAdmin as the cPanel user as well as for database credential logins as that same user (if any script is set to use the cPanel username).
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #6 cPanelTristan, Jun 27, 2012
(You must log in or sign up to post here.)
Loading...
Similar Threads - Wrong username password
  1. Dean Galbreath

    Wrong Domain displays on Website Lookup

    Dean Galbreath, Mar 18, 2019 at 4:31 PM, in forum: Bind/DNS/Nameserver
    Replies:
    1
    Views:
    43
    cPanelLauren
    Mar 20, 2019 at 9:22 AM
  2. dzamanakos

    In Progress [CPANEL-23998] Wrong PHP version detected after version change when using PHP-FPM and LiteSpeed

    dzamanakos, Mar 13, 2019, in forum: EasyApache
    Replies:
    3
    Views:
    296
    cPanelMichael
    Mar 15, 2019 at 12:01 PM
  3. Alessandro Ferrara

    Wrong files permissions on entire server

    Alessandro Ferrara, Feb 25, 2019, in forum: General Discussion
    Replies:
    1
    Views:
    105
    cPanelLauren
    Feb 25, 2019
  4. walid-mashal

    AWstats showing wrong number of unique visitors

    walid-mashal, Jan 27, 2019, in forum: General Discussion
    Replies:
    3
    Views:
    344
    cPanelLauren
    Jan 31, 2019
  5. greektranslator

    Server booted into wrong kernel

    greektranslator, Dec 6, 2018, in forum: General Discussion
    Replies:
    10
    Views:
    361
    cPanelMichael
    Dec 7, 2018

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.
    Accept Learn More...
    Dismiss Notice