To give another deviant a direct link to this FAQ answer, use the following code in your comment or forum post:
I forgot my password and need it emailed to me. Where can I do this?
You can do this by clicking on the 'Lost Password' link, located on top right hand corner of every page, under the deviantART header.
Please be aware that the Password Retrieval System does not send you a new password, it sends you a Confirmation Key which is used on the Verification page which is linked in the same email. When used there you will be allowed to change your password to something of your own choosing.
Do not attempt to use the Confirmation Key as your new password
If you have triggered multiple retrievals only the most recent Confirmation Key will be accepted.