blocked or deleted super admin in drupal: how to unlock or reset account

how to unlock super admin in drupal or restore it after deletingSome times you may accidentally lock the user 1, the super admin of Drupal, or deleting it. Apart from the look thrilled following the discovery of the error, do not despair and let us take immediately to work to unlock the super admin or restore the deleted account.
 
I quote here the two different procedures depending on whether we are talking about super admin block or delete user 1.
 
[adsense:block:adcontenuto]
 
Both procedures, however, require access to our hosting panel to enter in phpMyAdmin and manage our database. If you can not access the database, contact immediately your supplier to provide access or find a way to still be able to edit a field in a table.

How to unlock the super admin after accidentally blocking

We go into the control panel where is host our site in drupal and find the Mysql voice, the voice that usually identifies all the databases in hosting. While for some of the panels, phpmyadmin is available after we locate the database, however, in others (such as cPanel) will find PhpMyadmin already into the home of the panel.

 
Whichever way, we enter into phpmyadmin and in the left column, select the table "users" (if we have set a prefix, we will find the table like this: prefix_users). On the right will show all the users of the site and, in second place, after the user 0, the super admin account recognized by the fact that the has number 1 as uid.
 
Click on Edit next to the row containing the user and under "Status" insert 1 instead of 0.
Save and clicking Run under and our user will be unlocked.

How to restore the super admin after deleting

In case the problem is a total removal of the super admin then the procedure will be essentially the same as that just described in case of block. Therefore we repeat all the steps to get to the users table.

 
In this case the row containing the account does not exist, so the task is to recreate it. Then, on the top bar of the phpmyadmin pass in insert mode by clicking on the "Insert" and compile the essential fields:
 
Uid -> insert necessarily 1
Name -> We insert admin or another name
Pass -> The field is encrypted in MD5, so the advice is to find a web tool that converts text to MD5 (can be easily found by doing a search on google). We put our password, and then convert the we paste in the field Pass
Mail -> email administrator
Status -> We put the value 1
 
These are the essential fields to restore the account.
 
[adsense:block:adcontenuto]

 

Development: 

Comments

I have to thank you for the efforts you have put in writing this blog. I am hoping to view the same high-grade content by you later on as well. In fact, your creative writing abilities has encouraged me to get my own website now ;)

Greetings! Very useful advice within this article! It's the little changes that make the biggest changes. Thanks for sharing!

Similar Content

Dec. 21 2012 - Here's what will happen today ...

According to the Mayan calendar today should be the end

of the world as we have known it.
 
But the world is already finished, and no one has noticed it,
we really are living in a limbo hidden
without memory.
 
I have this certainty.
 
You just need make connections and strive to remember
some nights in which you find yourself placed during sleep, and
as it is recurrent, and how, by asking around,
this happens to more people than you think.
 
This year has seen everything, we realized
that religion, politics, the structure
society are all based on deception and
manipulation.

How to save Android battery: Tips, tricks and app to download

save android batteryAre you happy with your new Android smartphone, except for the fact that its battery almost never is able to arrive in the evening? Would you like to earn a few hours of battery life for your phone but you do not know how to do? Maybe I can give you a hand.

Considering that I can do not miracles, if you download the app I'm going to advise you and follow indications that you see below, you should be able to extend the battery life of your smartphone and arrive free from care at the end of the day. Here is how to save Android battery within the limits of the possible.

Mobile: 

Decline in the market for PC

Needless illusions, an era is now drawing to a conclusion would be: a drop in global sales of PCs around 1, 2% may appear content (especially in times of economic crisis) but the high tech and the minus sign should not be totally agree. When sales of a hi-tech stop growing, in fact, it often means that this has had its day and the market is changing course.
News Magazine: 

Guide and Download: Galaxy Note II upgrade to Android 4.1.2 Jelly Bean official N7100XXDLL4

galaxy note 2Samsung has just released in France and India the version N7100XXDLL4 for the second generation phablet that reports the following firmware data:
PDA: N7100XXDLL4
CSC: N7100OXADLL4
Version: 4.1.2
Date: 12/12/2012
Regions: Austria, Belgium, France, Germany, Hungary, Italy, Spain, United Kingdom
News Magazine: