Reset Password For Wordpress and VB in Mysql

WORDPRESS

1. Get an MD5 hash of your password.
2. Visit md5 Hash Generator, or...
3. Create a key with Python. or...
4. On Unix/Linux:
5. Create file wp.txt with the new password in it (and *nothing* else)
6. md5sum wp.txt
7. rm wp.txt
8. "mysql -u root -p" (log in to MySQL)
9. enter your mysql password
10. "use (name-of-database)" (select WordPress database)
11. "show tables;" (you're looking for a table name with "users" at the end)
12. "SELECT ID, user_login, user_pass FROM (name-of-table-you-found)" (this gives you an idea of what's going on inside)
13. "UPDATE (name-of-table-you-found) SET user_pass="(MD5-string-you-made)" WHERE ID = (id#-of-account-you-are-reseting-password-for)" (actually changes the password)
14. "SELECT ID, user_login, user_pass FROM (name-of-table-you-found)" (confirm that it was changed)
15. (type Control-D, to exit mysql client)

Referrence : http://codex.wordpress.org/Resetting_Your_Password

Eg: 

UPDATE `wparb_users` SET `user_pass` = MD5('passwordbaru' ) WHERE `wparb_users`.`user_login` = "admin" 

VBULLETIN

Eg:

UPDATE user set password = MD5(concat(MD5(''), user.salt)) WHERE userid =