Another booboo I made while moving my Wordpress blog to another server was entirely my own fault, I forgot the administrator password I had setup, myep. Here’s a way to manually correct this without using something like phpMyAdmin. I’m assuming you have root access to your web server.

Login to MySQL

To get the md5 hash for your password you have a few options, visit this md5 Hash Generator or let MySQL do it for you…

You should now be able to login to Wordpress again. Here is a useful article from Wordpress.org covering more ways to reset your admin password.