Reset drupal admin password

if you have fogotten your drupal admin password, this is ow to reset it

you need to access the database, either with phpMyAdmin or through the shell

from the shell

#mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 5.0.51a-3ubuntu5.1 (Ubuntu)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use database_name;
mysql> update users set pass=md5('NEWPASS') where uid = 1;
mysql> exit
#