Originally Posted by Mark Bolyard

For future reference, here is a easy fix for changing a password withing your database. Go to http://md5-hash-online.waraxe.us/ and type your desire password. Create the MD5 Hash. Copy and paste it over the md5 hash (password) in your database table, and save. Now you have your access.

I've had to do this a few times in vBulletin where I set up a test user and forget my password. Works like a charm.