# By Mistake Remove All Rights to Adminstrive USer

**URL:** <https://ask.gibbonedu.org/t/by-mistake-remove-all-rights-to-adminstrive-user/2665>\
**Category:** Developers\
**Created:** [July 24, 2020, 9:48am UTC](https://ask.gibbonedu.org/t/by-mistake-remove-all-rights-to-adminstrive-user/2665 "2020-07-24T09:48:49Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![vishalr](https://ask.gibbonedu.org/letter_avatar_proxy/v4/letter/v/41988e/32.png) [@vishalr](https://ask.gibbonedu.org/u/vishalr)\
**Post date:** [July 24, 2020, 9:48am UTC](https://ask.gibbonedu.org/t/by-mistake-remove-all-rights-to-adminstrive-user/2665/1 "2020-07-24T09:48:49Z")

</div>

Dear Support Team,

By Mistake, I have removed all Rights from Adminstiver Admin User, how can I have reset again.  
from which table?

---

<div class="post-metadata">

**Author:** ![vishalr](https://ask.gibbonedu.org/letter_avatar_proxy/v4/letter/v/41988e/32.png) [@vishalr](https://ask.gibbonedu.org/u/vishalr)\
**Post date:** [July 24, 2020, 10:42am UTC](https://ask.gibbonedu.org/t/by-mistake-remove-all-rights-to-adminstrive-user/2665/2 "2020-07-24T10:42:17Z")

</div>

Reset By phpmyadmin table (gibbonPermission)

---

<div class="post-metadata">

**Author:** ![sandra](https://ask.gibbonedu.org/user_avatar/ask.gibbonedu.org/sandra/32/5_2.png) [@sandra](https://ask.gibbonedu.org/u/sandra)\
**Post date:** [July 24, 2020, 10:51am UTC](https://ask.gibbonedu.org/t/by-mistake-remove-all-rights-to-adminstrive-user/2665/3 "2020-07-24T10:51:57Z")

</div>

Hi vishalr,

Oops! :grimace: Yep, you can reset this with PHPMyAdmin, if you open the gibbon.sql file in your Gibbon root folder, search for the `INSERT INTO gibbonPermission `section (line 2834 on v20). Copy that whole SQL command all the way down to the semicolon, then change INSERT to INSERT IGNORE. This will allow you to add all the missing permissions that admin normally have, and ignore any of the ones that already exist. It will also add default permissions to other users, if you don’t want that, you’ll have to manually remove the lines that don’t have 001 as the second value.`

`
Otherwise, if you happen to have a backup of your database, grab all the permissions from there and re-insert them with the INSERT IGNORE trick.
Hope this helps!`