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:
    6
    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:
    2,721
    Likes Received:
    186
    Trophy Points:
    143
    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:
    2,721
    Likes Received:
    186
    Trophy Points:
    143
    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...
  7. SigmaWeb

    SigmaWeb Active Member
    PartnerNOC

    Joined:
    Sep 26, 2006
    Messages:
    32
    Likes Received:
    3
    Trophy Points:
    158
    Location:
    Athens - Greece
    cPanel Access Level:
    Root Administrator
    Hi @cPanelLauren

    Could you please check if this could also be related to CPANEL-22372 ?
     
  8. cPanelLauren

    cPanelLauren Forums Analyst
    Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    2,721
    Likes Received:
    186
    Trophy Points:
    143
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    Hi @SigmaWeb


    CPANEL-22372 involves root mysql password changes separate from upgrades where CPANEL-20577 was only occurring after the upgrade. It's also safe to say that if you're running v74 of cPanel you should not be experiencing issues with the previous case and if you are continuing to experience issues with changing the MySQL root password in v74 of cPanel/WHM it could be the case you noted.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  9. SigmaWeb

    SigmaWeb Active Member
    PartnerNOC

    Joined:
    Sep 26, 2006
    Messages:
    32
    Likes Received:
    3
    Trophy Points:
    158
    Location:
    Athens - Greece
    cPanel Access Level:
    Root Administrator
    Thank you for the reply @cPanelLauren , I had this exact same issue last night when migrating to a new server (v74) and at the end I had to switch back to the old server, seems that there is no known workaround that fix this issue (you can have a look at my ticket 10171653 ). If it comes up a way to fix this, it would be great for us to know it.
     
  10. cPanelLauren

    cPanelLauren Forums Analyst
    Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    2,721
    Likes Received:
    186
    Trophy Points:
    143
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    Hi @SigmaWeb

    Based on what's discussed in that ticket and what's in the case I do want to note that it looks like the workaround to that is simply to manually change the MySQL password. I don't see that being done in the ticket was that something that you were able to test?

    I also want to note that while we have fixed the issue it has not been published yet, the case that you noted CPANEL-22372 is still in testing. It is slated to be released with 76 and backported to 70 and 74

    Thanks!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  11. SigmaWeb

    SigmaWeb Active Member
    PartnerNOC

    Joined:
    Sep 26, 2006
    Messages:
    32
    Likes Received:
    3
    Trophy Points:
    158
    Location:
    Athens - Greece
    cPanel Access Level:
    Root Administrator
    Thank you for the reply @cPanelLauren , in my case the change of the password didn't workout (in my see Aaron's reply: I am seeing the root password isn't working again.)

    Anyway, we will be waiting for the fix with 76, meanwhile is there is a workaround for those who need to change the root MySQL password it would be great to know.
     
  12. cPanelLauren

    cPanelLauren Forums Analyst
    Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    2,721
    Likes Received:
    186
    Trophy Points:
    143
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    Hi @SigmaWeb

    From What I'm seeing he said:

    Changing the password through the MySQL CLI should resolve this though - at least that's what I'm seeing in the case.

    Thanks!
     
    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