Migrate posts and photos from a blog to another

I’m assuming you have an sql file that you’re uploading?

If so, open that file in a text editor such as Notepad. Search for ‘user_login’, and somewhere nearby that you should see something similar to 'INSERT INTO wp_users (ID,user_login' etc. On the next line after this, you should see something like (1, 'admin', 'password' where ‘admin’ is the admin username, and ‘password’ is the hashed password.

You can’t login directly with that hashed password. But what you can do here is change the e-mail address listed on that line to one that you can access, then save the file.

Upload it into your WordPress install again, and this time follow the forgot password link. Enter that e-mail address you put in, and you should be able to reset the password!

Alternatively, you can use an MD5 generator like http://www.miraclesalad.com/webtools/md5.php, enter a new password there and copy the hash to replace the existing password in the SQL file. That will also let you log in with the new password.

Hope that helps!