To change your MySQL password, you will need to log into the Manage interface.
From within there, you simply click on SMARTSQL and select Change Password from within that section.
Your password change will propogate to the system within 30 minutes.
Please note that when the system completes your request, you may need to update the coding on your site which may reference your old MySQL password.