Does anybody know how to get this problem fixed? - By mistake the root mysql password in my WHM/CPanel were changed. I can't remember this new password. My current host has offered his help but can't do anything as the root password has changed. So we can't log in to WHM, neither to the server via SSH without this password. Can anybody tell me what to do?

Thanks
John

Your host will need to take the server and reboot it into single user mode, from there they can reset the root password.

http://www.cpanel.net/docs/whm/resetMySQLrootPassword.htm

might help

You mention two separate issues in your post:

1. A lost MySQL root password.
2. A lost root password.

If you want to retrieve your MySQL root password on a cpanel server run this command:

cat /root/.my.cnf

Now you need to run that as root in an SSH session. Since you don't have SSH access right now, here is how to reset your root password.

Someone at the data center needs to do this for you. Reboot your machine and at the lilo prompt have them type: linux -s

This will boot your machine into single user mode, tell them to make sure that the root partition is mounted and then have them run: passwd root

This should prompt them to enter a new root password. They just need to reboot your machine and then you are good to go again.

oops, sorry, didn't notice that root password had changed.

nice post ciphervendor.

Thanks alot for helping me with this situation :)

And now I'm anxiously waiting for the data center to fix it for me

John

oops, sorry, didn't notice that root password had changed.

I didn't expect the root password to change as the link in WHM said something like MySQL root password. I'm learning the hard way :( :)

John

I discovered that the data center set both the root and the mysql password to be the same. According to WHM this is not recommend (for what reason I don't know). - Anyway the data center did a single boot and reset my root password so now I can log in to WHM again. But since then when I create reseller accounts, following exactly the same procedure as I did before without any problems, I can't afterwards log in to the resellers account. Does anybody know what might cause this?

Also I'm confused over how WHM can mess up my root password when I only changed the mysql root password from within WHM.
Checking with cat /root/.my.cnf shows that the mysql root password were indeed changed so now they aren't the same at least. Hope that someone might know why it suddenly won't allow me to log in to reseller accounts I've just created.

John

The reason it is not a good idea to have your root MySQL password the same as your system root password is because if MySQL has a vulnerability revealing the root MySQL password many attackers will test to see if it is also a system password. This is a reason why you should always use a different password for everything you do.