Moving wp from a server to another, with different administrator

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:

  1. Import the old database.
  2. Open the user’s table, usually called ‘wp_users’.
  3. 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”.
  4. IMPORTANT: WordPress expects the password to be hashed as MD5. So before saving the record, set the ‘Function’ dropdown to ‘MD5’. See screenshot:

enter image description here

  1. 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:

  1. If you’re on Mac/Linux, do the following in terminal:
    openssl md5 <<< mypassword

  2. You can use an online generator

Related Posts:

  1. How do I migrate blog post images from one domain to a new one?
  2. Most Flawless Way To Transfer from Dev to Prod [duplicate]
  3. Suggestions for WPMU Migration (advanced)
  4. WordPress does not detect all images in uploads folder?
  5. Redirect to another page using contact form 7? [closed]
  6. bulk deleting empty items in the media library
  7. Broken image links in media library after restore
  8. Change the default-view of Media Library in 3.5?
  9. Get All Images in Media Gallery?
  10. Bind event on Media gallery elements WordPress
  11. Best way to import users, post and categories from an external database
  12. Remove the columns in media library
  13. How to migrate a WordPress installation from one site to another, including all images?
  14. How to save attachment data?
  15. How can I export WordPress posts’ attachments?
  16. How to enlarge thickbox media library iframe?
  17. How to modify Media Library images
  18. Inserting a Download Link in the Quick Edit Actions of the Media Library?
  19. How do I remove the entire Media section from the main WordPress navigation without just hiding it?
  20. How to migrate WordPress Blogs into Multisite without using the GUI-Import/Export Feature
  21. Add tab on new media library
  22. Copy site from one multisite to another
  23. What’s a better workflow for database migration?
  24. Is there any way to add images to the Media Library through a path on the server?
  25. Media Library page super slow, loading up full quality images
  26. How can I use the TinyMCE editor for the description field on a Media item?
  27. register_post_status invisible but searchable
  28. Bulk Import files on Media Library from CSV
  29. Hide upload image fields for the different media upload popups
  30. “Insert Into Post” For Custom Button
  31. Display image file size in media library
  32. Media_handle_upload with custom upload folder?
  33. Rebuild vs Upgrade – need pointers, advice
  34. remove_menu_page breaks “Add media”
  35. Organize media uploads in folders – I have a physical access to (my) server
  36. Pulling images from a subdomain
  37. Get image URL from media library “insert from url”
  38. Sorting Media Library by Author Name
  39. Media gallery: remove “insert into post” button keeping “Insert gallery” button
  40. Media Content disapeared after upgrade WP core to 3.5.1
  41. How do I fully migrate post images from one WordPress site to another?
  42. how to remove thumbnail and LiteSpeed Optimization column in media library list-view?
  43. wp_get_attachment_image_src returns the wrong image
  44. Intersept image upload and generate retina image from source
  45. Export + Import = wrongly duplicated content
  46. Crop image with full width
  47. WordPress media uploader – upload tabs not hiding
  48. Change Media Library thumbnails for non-image files to include the post title instead of the filename?
  49. attachment media-template data model (data.size.url)
  50. Problems with WordPress Import
  51. problem in uploading attachment to custom directory
  52. How do you alter the default WordPress thumbnail?
  53. Media Library, hook on delete user action
  54. Create a User Role with permissions to only upload files to the media library?
  55. Adding Alt Tag Column to Media Library List
  56. How to modify the attachment info text on gallery tab or media page?
  57. Add media button always inserts media on the next wp_editor instance when created dynamically
  58. Is it Helpful to transfer all media library to another host? [closed]
  59. Is there a way to determine if the media-iframe is visible?
  60. WordPress lowers image quality
  61. image not found in media library
  62. Is there a way to programmatically pass a category to the Media Library selector?
  63. Media Library http to https
  64. How to limit the amount of images uploaded to the media library within post.php
  65. Migrating my site to a new domain does not keep any changes made in customizer
  66. Change thumbnail size for Media Library
  67. Adding Facebook Open Graph Code does not work for Media Library Attachment Pages
  68. After migrating media library is not showing thumbnails
  69. How to fix custom add menu page preventing media library from loading
  70. custom/automatic export function – one post at a time?
  71. Media library corrupted after upgrading to 4.9.6
  72. Image paths wrong after migrating with wp-migrate-db-pro media files add-on
  73. Upgrading a wordpress site to its newest version
  74. Media import failed in the WordPress importer
  75. query that alternates text posts with images from media gallery
  76. Altered Media Library URLs
  77. Can multiple sites under one folder structure share media directories?
  78. Unable to delete images in Media Library
  79. WordPress Media Delete Logs
  80. WordPress not using edited image
  81. WooCommerce – Adding Product Attributes to CSV Export
  82. Is it possible to get an exported WP site in a zipped folder up and running? [closed]
  83. How to access media library?
  84. Migrate bbpress content to posts
  85. Create gallery doesn’t show uploaded images
  86. Media Library not showing images when adding to Posts (but retrieving image info via ajax)
  87. WordPress 3.5 Media Manager – Change loaded image Size [duplicate]
  88. Change the default-view of Media Library in 3.5?
  89. How use Videos from another directory?
  90. Media Manager 3.5 custom options
  91. Remove (Unattached) Attach from “Uploaded to” in Media Library
  92. Uploading pictures to the Media Library: “Specified file failed upload test.”
  93. WordPress Media Library
  94. Create media library feed
  95. Store images and videos category wise and fetch them in json format
  96. How to continuously developing a WP site that is already deployed in production without damaging it during development
  97. 2 or more WordPress instances (Live vs Staging Test site) –> access 1 uploads.domain.com — images holder – see images in Media Library
  98. media library contains corrupt doubles
  99. How can I change the page title of PDFs opened from a WordPress link which use the browser’s viewer?
  100. Files showing in link but cannot be found in the upload directory
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)