31Mar2011

How to reset Drupal admin password?

Tags:

There's nothing more frustrating than missing/lost your drupal admin password and you are locked in a situation where you don’t know what to do next. I have been in such situation and found a solution as well as wanted to share with you all.

The first thing to try is to click on the lost password link, and have the password emailed to you. There are, however, a couple scenarios where this will fail to work:

1. This won't work if you're unable to access the retrieve password page.

2. This won't work if you've stored an old, no longer in use email address for the admin user (user 1).

Resetting your Drupal admin password using phpMyAdmin

This is the best php tip I have found for reseting drupal administrator's password. You will need access to phpMyAdmin or some way to manage your database.
Follow the below steps to get your drupal admin password reset quickly:

1. Login to cPanel -> Databases box -> phpMyAdmin;

2. Select the Druapl database folder from the left navigation bar. The page will refresh and and the Drupal database’s tables will be displayed on it. (in case you don’t know the DB name, you can find it by looking into setting.php file)

3. Click on the SQL tab. In the text field write the following SQL query:

update users set pass=md5(‘NEWPASS’) where uid = 1;

You can replace “NEWPASS” with your new Drupal administrative password.

Restting admin password using Drush

If you are using Drush (a command line shell and scripting interface for Drupal), you can run the following line

drush php-eval 'db_query("UPDATE `users` SET `pass` = MD5(\"NEWPASS\") WHERE `uid` =1;");'

Note: Don’t forget to add table prefixes if your site uses them.

You can also find documentation  at Drupal.org for resetting admin password for Drupal 6 and Drupal 7
 

05Dec2009

How to Install Drupal on Shared Hosting Server?

Tags:

 Drupal is the best content management system I have ever come across. Besides being Open Source, Drupal has thousands of free contributed modules by Drupal enthusiasts and great community support. It has all the features necessary to build simple to complex web applications and portal websites. Installing Drupal is becoming easier and easier in each and every release. This article will show you how to install Drupal on your shared hosting server.

Step1:  Download the latest drupal installation files from drupal.org. 

Step2:  Using 7zip (free) or Winrar extract the file to a local folder

Step3: Upload the files to the server, for example: /public_html/example.com. Use a reliable FTP client like FileZilla to connect to your shared hosting server.

Step4: Login cpanel with your details and find MySQL databases

Step5: Once you clicked on MySQL database you will see a text field to create new database

Step6:  Create a new user (remember the password or take a note of it, you will need it later). Try to give password with different combination of characters. 

Step7: In the next step we need to give full permission to the database user. 

 

Step8:  We are almost there.  In your browser navigate http://www.example.com

You will see the following screen.  Click on “Install Drupal in English”.

As soon as you clicked you will get following error message within a red highlighted box . Don’t be panic.

Go to sites/default directory in your drupal installation directory (on the server) using ftp client and rename default.settings.php to settings.php

After renaming, go to your url and hit "try again". You will be taken to database configuration step where you need to enter database name, user name and password.

In the next step fill up the form with necessary details to create an admin account for your website. 

Finally we are done.  You will notice a welcome screen without any error and now click on "Your new site" and have fun with your newly installed site!

 

 

Subscribe via E-mail

Enter your email address:

What is Drupal?

Drupal is open source social publishing software that empowers individuals, teams, and communities to easily publish, manage and organize a wide variety of content on a website. Tens of thousands of people and organizations have used Drupal to power scores of different web sites, including community web portals, corporate web sites, social networking sites, personal web sites or blogs, and much more.

Blogroll

The Drupal-Tist