Skip to main content

Problem after mysql root change CPANEL 74 / MySQL Server

Gastón
Hi, I found a problem I can't understand. After a fresh installation CPANEL 74.0.6 With MySQL Server, when I try to change the MySQL Server Password from the WHM, it gives me an error and I can't enter to the MySQL Server anymore. I see the password change in the file /root/.my.cnf but the previous and new passwords are not available anymore. When I force a new password from "MySQL Root Passwords" the WHM gives me this: MySQL Root Password Updated the password for the active MySQL profile. MySQL password change failed!! A forced reset will now be attempted. Attempting MySQL Root Password Reset The MySQL root password was reset. Applications using MySQL will now be updated. Updating "DBcache" configuration " Failed " The subprocess reported error number 255 when it ended.Done Updating "Eximstats" configuration " updateeximstats: database schema is up to date. Success "Done Updating "Roundcube" configuration " Roundcube is configured to use SQLite. This update is for Roundcube using MySQL. Running /usr/local/cpanel/bin/update-roundcube-sqlite-db. Roundcube update from 1.3.3-5.cp1164 to 1.3.3-5.cp1164 in progress. Roundcube updated to 1.3.3-5.cp1164 Success "Done Updating "phpMyAdmin" configuration " Success "Done You have successfully changed "root""s MySQL password. The only way I found to get it to work again is to go to MySQL/MariaDB Upgrade and make the "upgrade" to mysql-server comunity edition (the same version I installed)

Comments

3 comments

Date Votes
  • Gastón
    Sorry I found this post is the same problem that I Have ?
    0
  • cPanelLauren
    Hi @Gast"n The issue you're experiencing sounds like the case noted in that thread CPANEL-22372 you should be able to manually change the password - this issue is resolved in v76 of cPanel/WHM and is set to be backported to v74 though that hasn't been done yet. Depending on whether or not you have a remote MySQL server added it could be CPANEL-22366 which is explained as follows: Resetting local mysql root password via WHM says successful but actually fails if remote server is also present Thanks!
    0
  • steven_h
    Experiencing this as well, so we won't recommend our +- 1k cPanel users to upgrade yet. At first I noticed the SQL-root password would fail to reset, it then forcibly generated a new password which was visible in the SQL error log, but not added to ~/.my.cnf I used a new installation today to doublecheck and oddly enough the SQL root password reset would succeed now, and no questions asked when using mysql in command-line, but mysql -u root -p will not accept the new password ( ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) ) . Turns out only the [client] section is updated in ~/.my.cnf Updating the other fields manually 'fixes' the issue. This is on a CentOS 7 installation btw with WHM/cPanel v74.06
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post