Lost Admin rights for user "admin"...

[ajerrom at latentzero.com]

Hi XWiki users,

I have an xwiki installation on my server and have restricted all users so they have to log in to view any pages. I then added content using admin user. I then added my ordinary users and wanted to give them edit rights only (once they have logged in). I saw that all users are in the Xwiki.XwikiAllGroup and figured this would be a quick and simple way of achieving this (but I assumed that “admin” had God like rights!) so I changed the settings to:

Groups: Xwiki. XwikiAllGroup
Access Levels: edit
Users: Xwiki.Admin
Allow/Deny: Allow

>From the original:

Groups: 
Access Levels: edit, admin, programming
Users: Xwiki.Admin
Allow/Deny: Allow

Now I have (very stupidly!) taken away the rights of the admin user! Is there any way I can run a Mysql script or SQL statement to add these rights back in for admin? Should I create a new group called AllNoAdminGroup and assign access levels to the ordinary users that way thus protecting the God like admin account?

Any help would be much appreciated because I have spent hours adding content as Admin and do not particularly want to reinstall and start again!

Thanks in advance for your help.

Best Regards,


Andy Jerrom.