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

Amazon introduces Coins, a virtual currency

 

amazon coinAmazon has presented a few days ago Coins, a new virtual currency that will be spent in the application store of the Kindle Fire from April 25, initially only in the U.S..
 
On the Kindle Fire, then, along with the ability to pay for the applications that you want to buy, you will add the option to pay in Coins. The exchange rate will be one U.S. cent per Coin, making the change very easy to maintain.
News Magazine: 

How advertising evolves on social networks

In the online advertising landscape, social networks represents a growing reality. Slowly, companies are picking up on the potential role of Sponsored Post, Promoted Tweet and so on.

Marketing Tech Blog has posted about this an interesting infographic created by Uberflip, entitled "The State of Social Ads".

Social Network: 

How to block Facebook in company

block facebook accesHave you a responsible role in a small company and do not want that your employees and / or collaborators wasting time on Facebook? Would you like to block access to social networks from the office computer but not being an expert on this kind of thing you do not know how to do? If you want, I can give you a hand.
 
There are several solutions that allow you to prevent access to websites and social networks in a simple way. All you need is just a bit 'of time at their disposal. If you want to know more, here's how to block Facebook in the company step by step.
Social Network: 

Tutorial Drupal Views: How to create a view

ui drupal views

Drupal Views: guide and notes
The Views module allows webmasters to drupal to create, manage and display lists of content and therefore a way of presenting the contents and tables. Essentially it is a query builder that, given some information, it can create queries, execute and lead to visual data in pages, blocks or other formats. Every single view can also have multiple views.
Development: 

Winning scheme by Bob Stone: formula in 7 steps

bob stone and direct marketingThe sales letter is one of the final and decisive steps of a good marketing campaign, you may have done a great job previous to carry you until the decisive moment, the purchase, but if you're wrong on this step then all the work will be in vain.

The sales letter is the key factor when it represents the instrument in the hands of marketers to convince the user to take the final step, the purchase. In this regard, it seems appropriate to remember the one who can be considered logically the father of Direct Marketing, which Bob Stone.

Web Marketing: