Forum Direct database query to reset admin password
 

What query will allow me to reset my admin password directly in the database?

Please don't tell me to use the lost password function or the tools.php as neither has worked for me yet.

I've tried:

mysql> UPDATE forum.user SET password=MD5('n3wpasswd') WHERE userid = 1;

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

Is the password seeded or ??

Thanks

bTal