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)
     
    #1 geokat, May 17, 2018
  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
     
    #2 sktest123, May 17, 2018
  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.
     
    #3 geokat, May 17, 2018
  4. cPanelLauren

    cPanelLauren Forums Analyst II Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    6,476
    Likes Received:
    507
    Trophy Points:
    263
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 cPanelLauren, May 18, 2018
  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.
     
    #5 geokat, Jul 15, 2018
  6. cPanelLauren

    cPanelLauren Forums Analyst II Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    6,476
    Likes Received:
    507
    Trophy Points:
    263
    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...
    #6 cPanelLauren, Jul 16, 2018
  7. SigmaWeb

    SigmaWeb Active Member PartnerNOC

    Joined:
    Sep 26, 2006
    Messages:
    33
    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 ?
     
    #7 SigmaWeb, Aug 24, 2018
  8. cPanelLauren

    cPanelLauren Forums Analyst II Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    6,476
    Likes Received:
    507
    Trophy Points:
    263
    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...
    #8 cPanelLauren, Aug 24, 2018
  9. SigmaWeb

    SigmaWeb Active Member PartnerNOC

    Joined:
    Sep 26, 2006
    Messages:
    33
    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.
     
    #9 SigmaWeb, Aug 24, 2018
  10. cPanelLauren

    cPanelLauren Forums Analyst II Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    6,476
    Likes Received:
    507
    Trophy Points:
    263
    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...
    #10 cPanelLauren, Aug 24, 2018
  11. SigmaWeb

    SigmaWeb Active Member PartnerNOC

    Joined:
    Sep 26, 2006
    Messages:
    33
    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.
     
    #11 SigmaWeb, Aug 24, 2018
  12. cPanelLauren

    cPanelLauren Forums Analyst II Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    6,476
    Likes Received:
    507
    Trophy Points:
    263
    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...
    #12 cPanelLauren, Aug 24, 2018
(You must log in or sign up to post here.)
Loading...
Similar Threads - Problem mysql root
  1. Kim_Vila

    Problem authenticating with root on MySQL (CLI)

    Kim_Vila, Apr 11, 2019, in forum: Database Discussion
    Replies:
    9
    Views:
    319
    Kim_Vila
    Apr 17, 2019
  2. Gastón

    Problem after mysql root change CPANEL 74 / MySQL Server

    Gastón, Aug 29, 2018, in forum: Database Discussion
    Replies:
    3
    Views:
    1,212
    steven_h
    Sep 17, 2018
  3. Nicola Urbinati

    New DB, MySql connection problems

    Nicola Urbinati, Jun 4, 2019, in forum: Database Discussion
    Replies:
    8
    Views:
    671
    cPanelLauren
    Jun 6, 2019
  4. NabiKAZ

    Problem installing mysqlnd_qc from Module Installers

    NabiKAZ, May 18, 2019, in forum: EasyApache
    Replies:
    3
    Views:
    1,543
    cPanelMichael
    May 29, 2019
  5. SamSpade

    Upgrade MySQL 5.6 to MariaDB 10.3 fails due to repo problem

    SamSpade, Mar 3, 2019, in forum: Database Discussion
    Replies:
    6
    Views:
    1,162
    cPanelMichael
    Mar 11, 2019

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