Resetting root password for mysql in WHM
Issue: while resetting root for mysql in whm, got the error belowMysql password change failed!! A forced reset will now be attempted.
Reset MySQL Password
Waiting for mysql to restart.....Done
Changing Password....Done
Reloading Mysqld...
Done
Waiting for mysql to terminate.....
Restarting MySQL ....Done
The MySQL root password has been changed.
Password changed for root to [passwordhere]
Resolution :
1) Try the following in-built cpanel scripts
# /scripts/realperlinstaller --force DBD::mysql
# /scripts/mysqlup --force
/root/.my.cnf has no " in root or password lines
# chmod 1777 /tmp
# service mysql restart
or
#/etc/init.d/mysql stop
#/etc/init.d/mysql start
Thats it ...issue is resolved.
posted by The Great Anil @ 9:33 PM
Comments: 0
