# 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:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Maestro](https://community.xibo.org.uk/letter_avatar_proxy/v4/letter/m/3bc359/32.png) [@Maestro](https://community.xibo.org.uk/u/Maestro)
#### Post date: [April 16, 2018, 8:15am UTC](https://community.xibo.org.uk/t/deleted-admin-users/14096/1 "2018-04-16T08:15:59Z")

</div>

Hello Dan

I have an issue with my accounts and user

By a mistake I did all my accounts as user include the ( super admin ) now I don not have super admin and I can not access the Xibo

it shows me ( you do not have permission to access this page )

Plaese help us

---

<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};`

---

<div class="post-metadata">

### Author: ![system](https://community.xibo.org.uk/uploads/default/original/2X/a/a8759c2d8cc561474733895ac75beeb830f5d8ca.png) [@system](https://community.xibo.org.uk/u/system)
#### Post date: [March 4, 2020, 5:10pm UTC](https://community.xibo.org.uk/t/deleted-admin-users/14096/3 "2020-03-04T17:10:48Z")

</div>


