One must be a registered Zoho User to use the Zoho Creator service. Registered users can sign-in into Zoho and proceed to use Zoho Creator. Alternatively, one can also directly log in into Zoho Creator. To use Zoho Creator:
In case you have lost/forgotten your password, use the "Forgot Password?" link available at the Zoho Creator login page (ex: https://www.zoho.com/creator/signin.html)
Enter your "Email Address" with which you had set up an account with Zoho, the "image text" that appears on the form and press the "Request" button.
You will be getting a mail with an HTML link, clicking on which you can choose a new password for your Zoho account.