How do i change admin pass through phpmyadmin

[Q-v-n-s-Q]

I lost my admin password, anyone know how to change password from phpmyadmin??

Edit: nvm i know how

[Marco van Herwaarden]

Just for reference, one of the solutions below could be used:
- Use the lost password link to get a password activation mail
- Upload tools.php from the do_not_upload folder in your vB zipfile to the admincp directory. Then go with your browser to admincp/tools.php and reset your access. Remove tools.php from your server

[bigcurt]

It is VERY important that tools.php gets removed also, otherwise anyone can get access to your board.

~Curt

[Marco van Herwaarden]

That is why i posted it in bold.