Error message

The spam filter installed on this site is currently unavailable. Per site policy, we are unable to accept new submissions until that problem is resolved. Please try resubmitting the form in a couple of minutes.

How to change your Drupal site admin password

  • Posted on: 26 October 2012
  • By: Pradeep George

When you work with different developement site, you often forget the passwords and some time need to spend a lot of time searching for it. In order to save your time quickly change the password to a new one, you can do the following 

1. Access your database, mostly using phpmyadmin
2. If you have multiple databases, select the one which corresponds to your site from list
3. Once you select it, click on th tab Query, which shown on top of the database tables
4. Enter the following line in the SQL query on database filed
5. Replace  yournewpassword with your own password
6. Click on submit query

update users set pass=md5('yournewpassword') where uid = 1;

Category: 

Add new comment

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.