Problem after mysql root password change

[geokat]

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)

 

[sktest123]

Can u please reset the password via whm -change mysql rootmpassword once again

 

[geokat]

I did it already and I have the same error.

 

[cPanelLauren]

Hi @geokat

MySQL has an init approach to resetting the password when something like this occurs. Can you try the steps outlined in their documentation here: MySQL :: MySQL 5.6 Reference Manual :: B.5.3.2 How to Reset the Root Password in the section
B.5.3.2.2 Resetting the Root Password: Unix and Unix-Like Systems


Thanks!

 

[geokat]

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.

 

[cPanelLauren]

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?

 

[SigmaWeb]

Hi @cPanelLauren

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

 

[cPanelLauren]

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.

 

[SigmaWeb]

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.

 

[cPanelLauren]

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!

 

[SigmaWeb]

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.

 

[cPanelLauren]

Hi @SigmaWeb

From What I'm seeing he said:

From what I'm seeing, this is related to CPANEL-22372 which is causing issues with the MySQL reset password option through the interface.

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

Thanks!