The easiest way around this is probably to reset the Admin password on the old Database. If you have PHPMyAdmin or a very similar DB admin interface, do the following:
- Import the old database.
- Open the user’s table, usually called ‘wp_users’.
- Find the user you wish to change the password for, and replace the contents of the ‘user_pass’ field with a plain text password. i.e “mypassword”.
- IMPORTANT: WordPress expects the password to be hashed as MD5. So before saving the record, set the ‘Function’ dropdown to ‘MD5’. See screenshot:

- Save the record and try to login.
If you don’t have PHPMyAdmin or similar and want to set the password manually in a SQL dump file, you can generate an MD5 hash of a plain text password in several ways:
-
If you’re on Mac/Linux, do the following in terminal:
openssl md5 <<< mypassword -
You can use an online generator
Related Posts:
- How do I migrate blog post images from one domain to a new one?
- Most Flawless Way To Transfer from Dev to Prod [duplicate]
- Suggestions for WPMU Migration (advanced)
- WordPress does not detect all images in uploads folder?
- Redirect to another page using contact form 7? [closed]
- bulk deleting empty items in the media library
- Broken image links in media library after restore
- Convert entire media library to WebP, delete original images and update references
- Change the default-view of Media Library in 3.5?
- Get All Images in Media Gallery?
- List of available events for wp.media
- Bind event on Media gallery elements WordPress
- Best way to import users, post and categories from an external database
- Remove the columns in media library
- How to migrate a WordPress installation from one site to another, including all images?
- How to save attachment data?
- How can I export WordPress posts’ attachments?
- How to enlarge thickbox media library iframe?
- How to modify Media Library images
- Inserting a Download Link in the Quick Edit Actions of the Media Library?
- How do I remove the entire Media section from the main WordPress navigation without just hiding it?
- How to migrate WordPress Blogs into Multisite without using the GUI-Import/Export Feature
- Add tab on new media library
- Copy site from one multisite to another
- What’s a better workflow for database migration?
- Is there any way to add images to the Media Library through a path on the server?
- Media Library page super slow, loading up full quality images
- How can I use the TinyMCE editor for the description field on a Media item?
- register_post_status invisible but searchable
- Bulk Import files on Media Library from CSV
- What should I do? A multisite, a single website or many websites? [closed]
- Hide upload image fields for the different media upload popups
- “Insert Into Post” For Custom Button
- Display image file size in media library
- Media_handle_upload with custom upload folder?
- Rebuild vs Upgrade – need pointers, advice
- remove_menu_page breaks “Add media”
- is there any hooks or action to fire function of insert into post in media library?
- Organize media uploads in folders – I have a physical access to (my) server
- Pulling images from a subdomain
- Get image URL from media library “insert from url”
- Sorting Media Library by Author Name
- Media gallery: remove “insert into post” button keeping “Insert gallery” button
- Media Content disapeared after upgrade WP core to 3.5.1
- How do I fully migrate post images from one WordPress site to another?
- how to remove thumbnail and LiteSpeed Optimization column in media library list-view?
- wp_get_attachment_image_src returns the wrong image
- Intersept image upload and generate retina image from source
- Export + Import = wrongly duplicated content
- Crop image with full width
- WordPress media uploader – upload tabs not hiding
- Change Media Library thumbnails for non-image files to include the post title instead of the filename?
- attachment media-template data model (data.size.url)
- Problems with WordPress Import
- date/time-picker and file upload (image) fields for custom fields (e.g. with more fields)
- Can I create my own custom Attachment Display Setting?
- Media library and posts list problems with WordPress on IIS
- Can I set multiple feature images to multiple posts from the media library?
- “add from media library” tab is super slow [closed]
- About to migrate site to new domain
- Reorder attachements in the media library
- Recalibrate _wp_attachment_metadata Image Dimensions
- How to transfer one domain to another domain without losing theme options (customizer)?
- Adding Alt Tag and Dimensions columns to Media Library
- WordPress localhost site always redirect to live site [closed]
- Extract url of every image in library?
- What would be the URL to display the WordPress image editor with an image from the media library?
- When moving a WordPress installation to a new server, why do I have to update each post before content shows?
- Using the media library for theme customization
- Prevent other editors from viewing images of other editors in Add Media Popup
- Media attachment date and post date
- Transferring theme and imported post attachments
- User media folder for each users on registration
- Larger preview thumbnails in Media Library
- How do you do your big exports / imports?
- How can I no-index specific PDF files in my Avada WordPress media library so that they don’t appear in search results?
- Filter media library by custom postmeta
- how to convert a wp multisite into a single site with content from subsites
- Can’t upload format files on media library
- How do you find a file in the media library using the file URL?
- How to make Media Library use HTTPS?
- Blank image thumbnails in media library
- Import all media referenced in posts
- When I’m in post editor and click on ‘Add media’, why won’t it load the media library with this code?
- How can I add a Description column to the media library browser screen?
- Get filenames of available image sizes
- How can I create more “create attachment” custom field – any idea?
- Host Images from Link
- Use the “Media Library” in Frontend
- The issue of redirecting my site to a new domain
- Why is my upload / Select media library button empty?
- All the Images in Media Library is showing broken links
- create a user’s owned folder on user registration
- cannot export data from CPT UI (books)
- Block non logged in users from accessing the media library
- Remove Edit Attachment Button in WordPress Mediathek -> see Screenshot
- Unable to upload media files: Maximum upload file size: 0 B [closed]
- I’m planning to offload my WordPress Media Library to a CDN? Would you recommend it, and why (or why not)?
- Adding a folder to word press Media Library
- Sharing media files between live and staging servers