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;