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

Identify harmful Web Shell with PHP Shell Detector

webshell php

A web shell is a script, commonly written in PHP, which can provide access as the root user to a web server compressed. Trojan also renamed PHP can be very harmful if used correctly by an attacker, it is therefore important to periodically analyze the platform's web in search of intruders.
Development: 

How to spy a mobile phone

how to spy a mobile phone

Have you ever thought to spy your friend’s mobile phone or reading all messages on your girlfriend’s mobile and listen all her calls too.  Maybe you haven’t done it yet because you haven’t found a simply and cheaper way. So reading this guide you can finally try to do it.

There are a lot of free or very cheaper solutions even if you should use them only to make some joke and not to violate the privacy of other people. In this way, in fact, you will commit a serious crime!

Mobile: 

Facebook, 1 hour blackout in Europe

Last night, many users have reported on Twitter that Facebook was not accessible. A few minutes later Anonymous posted a message in which the group of hacktivists claimed the attack on the servers of the social network. A spokesman for Menlo Park has denied everything, saying that it was a simple technical problem.

News Magazine: 

Anonymous, this time hitting the State Police

The hacktivist group most famous against the most sensitive Italian goal. The hole suffered by the server of the State Police at the hands of Anonymous last night marks a quantum leap in the company's shares, which - perhaps because they have abandoned WikiLeaks - seem to be devoting more and more data leaks and dedicate to public shares.
News Magazine: 

On Google+ comes the zoom on photos

zoom google+Short, but interesting. It is the latest news on Google+, shared on the social network by Dave Cohen, Google.
 
It is zooming, used by the user when viewing photos. Everything is connected, quite simply, to the mouse wheel: moving it forward or backward, it becomes possible to zoom in or out details and particulars.
News Magazine: