Problem after mysql root password change

geokat

Member
Jul 25, 2015
6
0
1
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)
 

cPanelLauren

Forums Analyst II
Staff member
Nov 14, 2017
8,012
648
263
Houston
cPanel Access Level
DataCenter Provider

geokat

Member
Jul 25, 2015
6
0
1
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.
 

cPanelLauren

Forums Analyst II
Staff member
Nov 14, 2017
8,012
648
263
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?
 

cPanelLauren

Forums Analyst II
Staff member
Nov 14, 2017
8,012
648
263
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.
 

SigmaWeb

Active Member
PartnerNOC
Sep 26, 2006
34
3
158
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.
 

cPanelLauren

Forums Analyst II
Staff member
Nov 14, 2017
8,012
648
263
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!
 

SigmaWeb

Active Member
PartnerNOC
Sep 26, 2006
34
3
158
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.
 

cPanelLauren

Forums Analyst II
Staff member
Nov 14, 2017
8,012
648
263
Houston
cPanel Access Level
DataCenter Provider
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!