You can do this by doing the following:
1. From your Cpanel, go to MySQL.
2. Delete the user that you want to change the password for completely. (this means from the database and from the User list).
3. Re-enter the username with your new password.
4. Associate the user with the correct database.
You are done!