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

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

  1. blaze64

    blaze64 Well-Known Member

    Joined:
    Feb 5, 2003
    Messages:
    159
    Likes Received:
    0
    Trophy Points:
    16
    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!
     
  2. cPanelNick

    cPanelNick Administrator
    Staff Member

    Joined:
    Mar 9, 2015
    Messages:
    3,426
    Likes Received:
    2
    Trophy Points:
    38
    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:
    16
    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.
     
  4. cPanelNick

    cPanelNick Administrator
    Staff Member

    Joined:
    Mar 9, 2015
    Messages:
    3,426
    Likes Received:
    2
    Trophy Points:
    38
    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:
    16
    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.
     
  6. blaze64

    blaze64 Well-Known Member

    Joined:
    Feb 5, 2003
    Messages:
    159
    Likes Received:
    0
    Trophy Points:
    16
    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.
     
  7. pagedeveloping

    pagedeveloping Well-Known Member

    Joined:
    Jun 11, 2003
    Messages:
    219
    Likes Received:
    0
    Trophy Points:
    16
    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:
    16
    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!
     
  9. mitul

    mitul Well-Known Member

    Joined:
    Feb 8, 2003
    Messages:
    291
    Likes Received:
    0
    Trophy Points:
    16
    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,
     
  10. mitul

    mitul Well-Known Member

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

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

    Thank you,
     
Loading...

Share This Page