cPanel – Reset MySQL db password
cPanel – Reset MySQL db password — How to reset mysql db password via cPanel ?
There is no reset option in cPanel for mysql database passwords. But you can overwrite existing password (as if a reset)
To change a password for a MySQL virtual user (a MySQL user created via cPanel), just create the same user again. The new user will overwrite the old user, and replace the old password in the process.
This is totally wrong!
To reset the MySQL password, simply log into WHM and select either:
1) “MySQL Root Password” (and change it) or
2) “Change a User or Database Password” (to change a specific password)
It’s as simple as that.
@Rama
Since you said, this is wrong, I went ahead manually confirmed this working in the following build
cPanel Version 11.24.5-STABLE
If you create a new username with the same name, with a different password, it gets overwritten.
Also, what you are telling is absolutely right, you can change password via method you posted (have updated in my post), BUT its only possible via WHM by administrators. What if a user needs to reset his database password, he can use the method i posted to do so via cPanel itself.