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!

Problem after mysql root password change

Discussion in 'Database Discussion' started by geokat, May 17, 2018.

Tags:
  1. geokat

    geokat Member

    Joined:
    Jul 25, 2015
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Athens
    cPanel Access Level:
    Root Administrator
    Hello,

    after change mysql root password mysql failed with errors like

    Updated the password for the active MySQL profile.
    MySQL password change failed!!
    A forced reset will now be attempted.
    Attempting MySQL Root Password Reset

    Trying to access phpmyadmin asks for password with error
    mysqli_connect(): (28000/1045): Access denied for user 'root'@'localhost' (using password: YES)
     
  2. sktest123

    sktest123 Well-Known Member

    Joined:
    Jan 31, 2017
    Messages:
    99
    Likes Received:
    5
    Trophy Points:
    8
    Location:
    kochin
    cPanel Access Level:
    Root Administrator
    Can u please reset the password via whm -change mysql rootmpassword once again
     
  3. geokat

    geokat Member

    Joined:
    Jul 25, 2015
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Athens
    cPanel Access Level:
    Root Administrator
    I did it already and I have the same error.
     
  4. cPanelLauren

    cPanelLauren Forums Analyst
    Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    1,814
    Likes Received:
    133
    Trophy Points:
    118
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. geokat

    geokat Member

    Joined:
    Jul 25, 2015
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Athens
    cPanel Access Level:
    Root Administrator
    What I found is that for some versions in 72.0.x when you try to upgrade from mysql to mariadb the basic tables of mysql were ending up crashed so try to change root pass after that was a failed procedure. If the installation was new like in my case what I tried and worked was to rename the mysql folder and force the mariadb upgrade once more. The mysql folder was created again with new tables and the problem solved. I cannot imagine what might happened when you have accounts in an old installation. It could be a disaster.
     
  6. cPanelLauren

    cPanelLauren Forums Analyst
    Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    1,814
    Likes Received:
    133
    Trophy Points:
    118
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    Hi @geokat

    I actually believe I may have found an internal case that addresses this CPANEL-20577 and while it is fixed in v72 of cPanel it looks to have been fixed in a version of v72 after your starting this thread officially added to ChangeLogs on 5/31/18. It appears to be a workaround for a MariaDB bug https://jira.mariadb.org/browse/MDEV-16238

    Can you please let us know if it continues to occur now that we can confirm there was a case that is noted as being resolved?
     
    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