How to recover configuration privileges for admin user?

[jrivel]

So I accidentally reset the permissions for the Admin user and I no longer have configuration access. Also, the one other user I had setup also has no configuration access. Do I need to drop the database and start again? Or is there a way to recover the configuration priveleges for the Admin user.

Thanks,
Josh

[just2blue4u]

which DB do you use?

Log in into DB...
Remove all rights for admin user (ID #1).
Then say

INSERT INTO `rights` VALUES (1,1,'Default permission','U',0),(2,1,'Default permission','A',0)

another browser reload, and everything should be ok again.

try it, but think about making another DB backup before!

[jrivel]

Thanks for the tip. I actually deleted the admin user and recreated it via mysql and that worked fine.

[wyatt121]

Hi,

How did you recreate the admin user in mysql?

Wyatt