> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://docs.clientexec.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# Lost Administrator password

If you have lost your administrator password and are unable to retrive it via the "Forgot Password" tool follow the instructions below.

(**Always backup your database before running any SQL command. Clientexec holds no responsibility for lost or damaged database information**)

1.  Login to your phpmyadmin.
2. To the left select the Clientexec Database created.
3. In the top tab, select the SQL tab.
4. In the input box put:

```
SELECT id FROM users where email='your@adminemail.com';
```
* replace your@adminemail.com with your admin email.

![](https://storage.crisp.chat/users/helpdesk/website/895a2775afb3f800/screenshot-2024-03-01-at-11-30_zxazhr.png)

5. In the results, your userid will be shown under the id column (this is usually 100)

![](https://storage.crisp.chat/users/helpdesk/website/895a2775afb3f800/screenshot-2024-03-01-at-11-32_12b5ax.png)

6. To the left select the Clientexec Database created.
7. Click the "user_customuserfields" table.
8. Search for the userid you got in step 5 (usually 100)
9. There will be a row with a value that starts with sha256: - Edit this row replace the content with:

||| sha256:1000:zXl1BYRjrzoi8O85WiokmYvalq2v2bcT:oap3kmurV2ucXKbE/v7hb0jnCJ15tZNv

10. This will reset your admin password to _nE6cX3fA6yC8vI9f_
11.  Once you are able to log back in to the admin area you can then go and change your admin password to one of your choosing.

If you run into any difficulties you can open a Support ticket [here](https://www.clientexec.com/members/index.php?fuse=support&controller=ticket&view=submitticket) or open a Live Chat.