By derek_lee on

Being totally careless and probably drunk, I blocked my own account (which is the only one with admin features).

How do I unblock myself when I can't even log in as admin?

After you've stopped laughing I would appreciate some help.

Thanks

Comments

chrisada’s picture

chrisada commented

This sounds dagerously fishy. But if it's indeed your site, you can edit the MySQL table manually. (table 'users')

Dublin Drupaller’s picture

Dublin Drupaller commented

recommend you try navicat to edit the users table..

it's a freebie for 30 days trial...I find it very useful as I'm not very sql or php savvy. Similar to myphp_admin and others...but more user friendly for thickos like me.

http://www.navicat.com

J

Currently in Switzerland working as an Application Developer with UBS Investment Bank...using Drupal 7 and lots of swiss chocolate

killes@www.drop.org’s picture

killes@www.drop.org commented

You can use the mysql client or phpMyAdmin to set the password as follows:

update users set pass = MD5('new password') where uid = 1;

See http://bfl.rctek.com/guides/?guide=md5#changepma

--
If you have troubles with a particular contrib project, please consider to file a support request. Thanks.

--
Drupal services
My Drupal services

chrisada’s picture

chrisada commented

I thought the problem was user's status was changed from 'active' to 'blocked'?

killes@www.drop.org’s picture

killes@www.drop.org commented

Oops, yes.

Well then it is:

update user set status = 1 where uid = 1;

--
If you have troubles with a particular contrib project, please consider to file a support request. Thanks.

--
Drupal services
My Drupal services

sepeck’s picture

sepeck commented

Hmmmm. This info should probably go in the handbook, the logical place would be in administration.... perhaps troublshooting, but there is no user management section.

I'll see if I can think of something specific by this weekend to propose and do, perhaps other people can come up with a better idea.

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

Anonymous’s picture

Anonymous (not verified) commented

Thank you for being silly ahead of me so this thread was waiting with the answer I needed :)

sepeck’s picture

sepeck commented

Added to troubleshooting section for future reference
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

mareshal’s picture

mareshal commented

It happened that i .... mmmm... forgot the admin pass. And then i ran an sql query and it worked. so, thanx guys, i was thinking of running the querry but didnt know if it will work.

thnx .