DRUPAL Tips

By donmc, 18 August, 2009

Resetting your Drupal admin password

To directly reset your password, log into phpMyAdmin and execute the following mySQL statement:

UPDATE users SET pass = md5('newpassword') WHERE uid = 1;

To drop/create a new database:

# mysql -u donmc -p
mysql>
mysql>
mysql> drop database my_database_name;
mysql> create database my_database_name;
mysql> grant ALL on my_database_name.* to myusername@localhost;
mysql> use my_database_name;
mysql> flush privileges;
mysql> exit;
#

And here are the commands bare for you to copy/paste after you edit the data...

drop database my_database_name;
create database my_database_name;
grant ALL on my_database_name.* to myusername@localhost;
use my_database_name;
flush privileges;
exit;