By mr.v. on

Okay, so I just installed drupal 5.1 and began adding users and setting things up. Since this is for a private little site, but I want to access it from outside the local network, I decided that only administrators should be allowed to add users. We don't have many people so it wasn't a big deal.

However, to accomplish this I started by going to some sort of filter tab and set that new usernames should not be '%' with the thought that it would simply block anyone from trying to register since it wouldn't allow any new user names to be added. While still in the same session, I LATER found found a tab with a button that said, duh, only Administrators can add users...

So I obviously clicked that, but I forgot to remove the filter blocking with %.

NOW, I cannot login with my administrator account because it will give me the message: "The name Administrator is a reserved username"
It gives me that message for everything. Obviously the filter seems to block not only creation of new accounts but logging in too!

Is there any way to delete the filter using a mysql query? Or am I sunk? Should I delete everything, start over, and take this as a life lesson...?

Thanks for the help!

⋅ Categories: Drupal 5.x

Comments

pwolanin’s picture

pwolanin commented


Go into your database and truncate or delete all entries from the {access} table.

e.g. for MySql "TRUNCATE TABLE access"

---
Work: BioRAFT

mr.v.’s picture

mr.v. commented

Thanks! That worked fantastically!