# Deleted admin users

**URL:** https://community.xibo.org.uk/t/deleted-admin-users/14096
**Category:** Get Help
**Created:** [April 16, 2018, 8:15am UTC](https://community.xibo.org.uk/t/deleted-admin-users/14096 "2018-04-16T08:15:59Z")
**Posts on this page:** 1
**Showing post:** 2

<div class="post-metadata">

### Author: ![kenneth](https://community.xibo.org.uk/letter_avatar_proxy/v4/letter/k/94ad74/32.png) [@kenneth](https://community.xibo.org.uk/u/kenneth)
#### Post date: [April 18, 2018, 1:11pm UTC](https://community.xibo.org.uk/t/deleted-admin-users/14096/2 "2018-04-18T13:11:04Z")

</div>

You would need to access your database to reset your user as Super Admin.

If you are using a Docker Install, see the following instructions in FAQ to connect to your database.

> [@How can I run a SQL command when using a Docker Install?](https://community.xibo.org.uk/t/how-can-i-run-a-sql-command-when-using-a-docker-install/9946):
>
> While troubleshooting an issue you maybe asked to run a SQL statement on your database Docker container, or you may want to run a statement yourself for another purpose. To do either of these things there are two options. Using the command line Using the GUI called PhpMyAdmin Command Line Before you can run a statement inside the docker container you will need to find the container name. This can be done using the docker ps command. The resulting output will show a list of running docker con…

Once connected, use the below SQL commands to help find your user and change your user’s User Type.

`SELECT UserID, usertypeid, UserName from `user`;`

Identify the UserID of your user

The usertypeid values represent the below User Types.  
1 - super admin  
2 - group admin  
3 - user

You will need to change usertypeid to 1 for your UserID

`UPDATE `user` set `usertypeid` = 1 WHERE `UserID` = {UserID};`

---

_[View the full topic](https://community.xibo.org.uk/t/deleted-admin-users/14096)._
