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 errors (root)

Discussion in 'Database Discussion' started by blaze64, Jan 19, 2004.

  1. blaze64

    blaze64 Well-Known Member

    Joined:
    Feb 5, 2003
    Messages:
    159
    Likes Received:
    0
    Trophy Points:
    166
    Is anyone else having trouble logging in as root to phpmyadmin? Here is what I see after attempting to change the root MySQL password via WHM:

    However, using cPanel, users on that server CAN connect to phpmyadmin with no issues. It just seems to be ROOT that can NOT login or run MySQL commands as ROOT.


    Geezzzz... this is CRAZY and ANNOYING!


    THANKS!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. cPanelNick

    cPanelNick Administrator
    Staff Member

    Joined:
    Mar 9, 2015
    Messages:
    3,480
    Likes Received:
    30
    Trophy Points:
    158
    cPanel Access Level:
    DataCenter Provider
    Use the RESET mysql password function.
     
  3. blaze64

    blaze64 Well-Known Member

    Joined:
    Feb 5, 2003
    Messages:
    159
    Likes Received:
    0
    Trophy Points:
    166
    I did... But one of your techs (Cliffard) answered my ticket with the reply "Root can not login to phpmyadmin".

    Anyway, I can't enter mysql via SSH to change it or change it via WHM.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. cPanelNick

    cPanelNick Administrator
    Staff Member

    Joined:
    Mar 9, 2015
    Messages:
    3,480
    Likes Received:
    30
    Trophy Points:
    158
    cPanel Access Level:
    DataCenter Provider
    Please use the reset, not change password function.
     
  5. blaze64

    blaze64 Well-Known Member

    Joined:
    Feb 5, 2003
    Messages:
    159
    Likes Received:
    0
    Trophy Points:
    166
    I suppose I am lost... unless you are referring to something like this:

    http://www.mysql.com/doc/en/Resetting_permissions.html

    If that is what you are refering to, that dosen't work either.
    I always seem to see the error:

    ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES

    Even when I use SSH or WHM, it dosent matter. Like I said, in WHM, when I try to reset the MySQL password, I get the above error althought it DOES update the my.cnf file in /root/ I just see the above error and continue to get the error each and every time I try to access MySQL as root

    I am running 2.5.2, which I guess is cPanel's stable version.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  6. blaze64

    blaze64 Well-Known Member

    Joined:
    Feb 5, 2003
    Messages:
    159
    Likes Received:
    0
    Trophy Points:
    166
    This issue is actually server wide. I can not go into cPanel and create users or databases. Any auto intaller that is attempted FAILS. I assume due to the fact that a connection can not be made.... by anyone.

    And when in cPanel, the current list of users / databases does not show up. The boxes are empty as if there are no users or databases setup.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  7. pagedeveloping

    pagedeveloping Well-Known Member

    Joined:
    Jun 11, 2003
    Messages:
    219
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    New York
    It looks as if your MySQL is down, did you check inside the WHM server monitor?

    What version of redhat are you running? or OS for this matter.

    Try to

    killall mysqld
    /etc/rc.d/init.d/mysql stop

    and log back into WHM and reset MySQL again
    perhaps it cant reset while to many processes are running.

    than log back in via ssh as root and start up MySQL

    /etc/rc.d/init.d/mysql start
     
  8. blaze64

    blaze64 Well-Known Member

    Joined:
    Feb 5, 2003
    Messages:
    159
    Likes Received:
    0
    Trophy Points:
    166
    FINALLY!!! I got it!!!!

    I can now get into MySQL and also login as ROOT to phpmyadmin.... wow!!

    If you have to use the reset password option under mysql, be sure to kill some services off before doing so or WHM freaks out and dosent change it.

    Thanks to everyone for the help!

    P.S. No matter what the techs at cPanel tell you, you CAN login to phpmyadmin as ROOT and manage all of the databases!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  9. mitul

    mitul Well-Known Member

    Joined:
    Feb 8, 2003
    Messages:
    291
    Likes Received:
    0
    Trophy Points:
    166
    Please let me know which other services i need to stop, I m having simmilar issue and tired Reset Mysql from WHM which tell me mysql password is blank but gives me same message .

    Thank you,
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  10. mitul

    mitul Well-Known Member

    Joined:
    Feb 8, 2003
    Messages:
    291
    Likes Received:
    0
    Trophy Points:
    166
    OK ! ;)

    I resolved it, by executing /scripts/fixmysql which did the work.

    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