Login to WHM as root and go to Account information>List Accounts click on the + sign for the domain you need to change the password and select the option "Sync MySQL password with account password" and change password.