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.
Refresh Type the characters you see in this picture. Type the characters you see in the picture; if you can't read them, submit the form and a new image will be generated. Not case sensitive.  Switch to audio verification.