Locked out of admin account help? phomyadmin

[Keesa]

My forum has two problems.

1. I forgot my password.
2. The forum is not sending password reminders or any email to new members.

How can I change my pass in phpmyadmin?

I found this, but it is not working

UPDATE <prefix>user
SET password = MD5(CONCAT(MD5('new-password'), salt))
WHERE userid = x

[nerbert]

Get your salt value from the user table and PM it to me. I will make up a password and PM that back with the hashed value to edit into your password value in the user table