By garietc on

Okay...I know this is kind of silly, but I blocked my admin account on accident, and now I can't log back into my site as the administrator. I just get a "the username Administrator has not been created or is blocked" message.

Could somebody please help me out here?
(and I''m not particularly proficient with databases and things, so if the solution involves mysql trickery, I'm going to need some highly detailed instructions).

Thanks

⋅ Categories: Drupal 5.x

Comments

sepeck’s picture

sepeck commented

Troubleshooting-FAQ
http://drupal.org/node/52013

-Steven Peck
---------
Test site, always start with a test site.
Drupal Best Practices Guide -|- Black Mountain

-Steven Peck
---------
Test site, always start with a test site.
Drupal Best Practices Guide

garietc’s picture

garietc commented

But not quite right. I didn't set any rules. I just checked the "block account" button under the Administrator's profile.

In the example, on http://drupal.org/node/52013, there is a list of user names. I've been scouring my drupal database on phpMyAdmin, and can't find any references to usernames.

When I click on "access", I get a table with the following fields: aid, mask, type, status. And below that, there is another table called "Index" that just has the keyname: PRIMARY.

My apologies if I'm missing something obvious here. I just don't understand what I'm looking at.

tm’s picture

tm commented

you are looking for the "user" table... the comment on the page is not relevant to your situation.

garietc’s picture

garietc commented

With all of the user names. There are a bunch of fields like "uid, name, pass", etc.
The administrator is listed there with the rest of the users, but I don't understand what I am looking at exactly.
Which information relates to blocked users? And how do I change that?

tm’s picture

tm commented

according to the handbook page, you want to set "status" to "1" for the user having the problem. in this case, your admin user.

garietc’s picture

garietc commented

Hooray! Thanks for the help, everybody. Here's what I did:

Within phpMyAdmin, I navigated to my drupal database, and then selected "users". I then hit the "Browse" tab, which listed all of my users and their permissions. Then, I selected my admin account, clicked "edit", and changed the status from "0" to "1". Awesome.

sepeck’s picture

sepeck commented

Ya, I didn't have time to write a full message there earlier, so just grabbed the link. Also, don't have phpMyAdmin either. :) Glad you got it.

-Steven Peck
---------
Test site, always start with a test site.
Drupal Best Practices Guide -|- Black Mountain

-Steven Peck
---------
Test site, always start with a test site.
Drupal Best Practices Guide

bafa’s picture

bafa commented

Would you mind sharing how to use phpmyadmin? I just made the same mistake but am very new to Drupal and am trying to teach myself how to create a website. Unfortunately Im so new that I had never heard of mysql or phpmyadmin and seem to be at a road block. Any suggestions or places for first timers to check out to help with these issues? Thanks!

colinf’s picture

colinf commented

You can normally access phpmyadmin from your host user controll panel under databases. Dont let it confuse you, i stay away from it, as drupal normally allows you to stay well clear and not get bogged down. But following the items mentioned 3 steps above solved my problem . You can read up on this here http://www.phpmyadmin.net/home_page/index.php