Login after Blocking user 1 by an access rule

Last modified: November 2, 2008 - 23:59

Say you accidentally 'block' your admin account (user 1) by an access rule (for example "%admin%") and cannot log in. You can undo this by accessing the table access and deleting the row where the mask field contains the access rule (in our example "%admin%".)

Using phpMyAdmin this is done by:

  1. Clicking on the name of the drupal database in the left menu (e.g. "_Drupal")
  2. Beside the table name (access) and under the Action column click on the Browse icon.
  3. Find the row in the table with the mask field (e.g. "%admin%") and click on the delete icon beside it.
  4. Press OK on the confirmation message.
  5. Now login normally from the frontpage...

Thanks

cliffdiver1 - May 5, 2009 - 04:01

... I just did exactly this- %admin% . I was trying to prevent anyone from registering with a username like "administrator" and posing. So how would I go about this? I want to make sure that my unique usernames of special privileges are not wolves in sheep's clothing.

Login after blocking user

toormore - May 19, 2009 - 22:43

Hi
I followed this procedure but when I got to the Browse Icon, it was grayed out and I was unable to click and find the %admin%.
I am pretty new to Drupal so that's unfortunately as technical as I get.

Thanks in advance

Must be disable this option when login with user 1

jeros - September 16, 2009 - 17:51

I thing in the next release of Drupal, it must fix this ridiculous thing. I ask to the developer to make change that the user cannot block himself at access rule administer (especially to user 1).
Sorry for my bad english.

 
 

Drupal is a registered trademark of Dries Buytaert.