Smart Cleanup Tools is an easy to use, powerful plugin for database cleanup with total of 37 cleanup, reset and removal tools. With this plugin you can remove data that is no longer in use, or it is unneeded.
Other Features
WordPress Toolbar Menu with quick access and cleanup options
Tools to...
You can use this query to reset a user's password. It is especially useful if you forget your admin password.
You need to replace new-password and 1 (the user_id). You don't have to change salt, but if you do then both instances need to be the same.
UPDATE xf_user_authenticate
SET data =...