To reset your database password, click MySQL Database in myCP, then click the Users link for the appropriate database.  On the following page, enter and confirm the new password.